Re: [PHP-DB] Re: PLS Advise, Highlighted Text from a Query

2003-06-19 Thread nabil
thanks so much for your help , but would help me more to implement the example : $query = open source world, open mind for all; $text = open; . . $count = 0; $keywords = (split $query into array of whole words); for (each word in $query) { $n = (number of times $word found in $text); $count +=

[PHP-DB] MySQL editor

2003-06-19 Thread Angelo Zanetti
Hi all. I need to get a program (interface) for MySQL, I was using MySQL Front but they've discontinued its use. Any suggestions. thanx in advance -Angelo

Re: [PHP-DB] MySQL editor

2003-06-19 Thread Achilles Maroulis
MySQL CONTROL CENTER from mysql.org (very nice) SQLYOG from sqlyog.com PHPMYADMIN from phpmyadmin.net (web interface) - Original Message - From: Angelo Zanetti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19,

Re: [PHP-DB] MySQL editor

2003-06-19 Thread Ignatius Reilly
Try also DBTools (forWindows). Very nice. Been using for 2 years, and happy about it. http://www.dbtools.com.br/EN/ Ignatius _ - Original Message - From: Achilles Maroulis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:46 AM Subject: Re:

[PHP-DB] re: Lastest versionof PHP

2003-06-19 Thread Jon Miller
I would like to install php-4.3.2 on a RHL7.3 server. Is there a rpm for RH servers? Alsoshould I upgrade RHL to 8 or stay with 7.3. The only other app on the server is: MySQL-Max-4.0.13-0 MySQL-server-4.0.13-0 MySQL-devel-4.0.13-0 MySQL-client-4.0.13-0 I believe there is a newer version of this

Re: [PHP-DB] MySQL editor

2003-06-19 Thread CPT John W. Holmes
Next time ask on the MySQL list! Navicat Mascon PHPMyAdmin (for web interface) SQLYog MyCC (from www.mysql.com) The first two are very professional programs that offer a lot of features including Reports and Query wizards. Similar to using Access on Windows (interface wise), but without the

Re: [PHP-DB] Re: order by an average in another table (basicallya top 10 list)

2003-06-19 Thread Milan Babuskov
chris wrote: I managed to figure it out on my own. For those curious, here's a starting point: SELECT parent_id, avg(rating) as average FROM ratings WHERE average IS NOT NULL GROUP BY parent_id ORDER BY average DESC, parent_id DESC It works in MySQL 3.x, but not certain about PostgreSQL. The

Re: [PHP-DB] MySQL editor

2003-06-19 Thread Michael Scappa
Not free, but mysqlmanager (www.ems-hitech.com) is by far the best I've used. A free alternative (although not quite as featured) is probably Mysqlcc -Mike - Original Message - From: Angelo Zanetti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:40 AM Subject:

Re: [PHP-DB] Re: order by an average in another table (basically a top 10 list)

2003-06-19 Thread Michael Scappa
what version of postgres, newer ones handle null values slightly differently in queries, although there is a setting you can switch to make it work like the older versions. -mike - Original Message - From: Milan Babuskov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19,

Re: [PHP-DB] MySQL editor

2003-06-19 Thread Pierre-Alain Joye
Hello, Not really the same purpose, but so powerfull :) http://www.fabforce.net/dbdesigner4/ pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql Editor

2003-06-19 Thread Michael Lewis
A free alternative that works very well is sqlyog. Google it as I don't have the url handy (it may be www.webyog.com or .org). I also use MySQL Front as it still works fine. But I'm switching over to sqlyog because I want to ensure that I am compatible with future releases of MySQL. Michael Lewis

RE: [PHP-DB] mysql Editor

2003-06-19 Thread Ryan Marrs
DBTools - www.dbtools.com.br ___ Ryan Marrs Web Developer Sandler Travis Trade Advisory Services, Inc. 248.474.7200 x 183 248.474.8500 (fax) www.strtrade.com -Original Message- From: Michael Lewis [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003

Re: [PHP-DB] MySQL editor

2003-06-19 Thread Becoming Digital
mysqlmanager (www.ems-hitech.com) is by far the best I've used. They've changed the name to Navicat now. It really is fantastic software. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Michael Scappa [EMAIL PROTECTED] To: Angelo Zanetti [EMAIL

[PHP-DB] Fw: php-db Digest 17 Jun 2003 06:02:39 -0000 Issue 1886

2003-06-19 Thread rafael2
The digest files are coming as attachments Attachmnts are very light (just 900 bytes or some 2 or 4 Kb. This one carries a whooping 46 KB. Any added spyware or so ? Thanks Raf - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 3:02 AM

Re: [PHP-DB] MySQL editor

2003-06-19 Thread Becoming Digital
Sorry, I mistyped. Navicat was previously known as MySQL Studio. Both are very nice packages. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Becoming Digital [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, 19 June, 2003 11:02 Subject: Re:

Re: [PHP-DB] MySQL editor

2003-06-19 Thread Michael van der Poel
SQL4x Manager is great, too, but it only runs on the mac platform http://www.macosguru.de/products/sql4xmanager on 19/6/03 5:34 PM, Becoming Digital at [EMAIL PROTECTED] wrote: Sorry, I mistyped. Navicat was previously known as MySQL Studio. Both are very nice packages. Edward Dudlik

Re: [PHP-DB] Fw: php-db Digest 17 Jun 2003 06:02:39 -0000 Issue 1886

2003-06-19 Thread Becoming Digital
Any added spyware or so ? I believe someone sent a few attachments to the list. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, 19 June, 2003 12:35 Subject: [PHP-DB] Fw: php-db Digest 17 Jun

RE: [PHP-DB] MySQL editor

2003-06-19 Thread Creative Solutions New Media
With the exception of phpmyadmin is there anything else out there that will allow you to work on your mysql stuff remotely? Tim Winters Manager, Creative Development Sampling Technologies Incorporated (STI) [EMAIL PROTECTED] [EMAIL PROTECTED] W: 902 450 5500 C: 902 430 8498 -Original

Re: [PHP-DB] MySQL editor

2003-06-19 Thread David Shugarts
Thus, the website to find Navicat is http://www.mysqlstudio.com. --Dave Shugarts Sorry, I mistyped. Navicat was previously known as MySQL Studio. Both are very nice packages. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Becoming

Re: [PHP-DB] MySQL editor

2003-06-19 Thread Jason Wong
On Friday 20 June 2003 01:11, Creative Solutions New Media wrote: With the exception of phpmyadmin is there anything else out there that will allow you to work on your mysql stuff remotely? They should all allow you to access a remote installation of mysql. Now can we please move this topic to

Re: [PHP-DB] MySQL editor

2003-06-19 Thread CPT John W. Holmes
With the exception of phpmyadmin is there anything else out there that will allow you to work on your mysql stuff remotely? Any of the programs will. The real questions whether you have permission to connect remotely, though... :) ---John Holmes... -- PHP Database Mailing List

[PHP-DB] Problems with formvalues by using Suse 8.2

2003-06-19 Thread Ruprecht Helms
Hi, under using Suse 8.2 I've the problem that the values of formfields will be put out or worked withit within a phpscript. The testscript with phpinfo() is working fine. What have I to set (in the php.ini) that php is handling the formfieldvalues properly? Regards, Ruprecht -- PHP

Re: [PHP-DB] Problems with formvalues by using Suse 8.2

2003-06-19 Thread CPT John W. Holmes
under using Suse 8.2 I've the problem that the values of formfields will be put out or worked withit within a phpscript. The testscript with phpinfo() is working fine. What have I to set (in the php.ini) that php is handling the formfieldvalues properly? I really have no idea what you

[PHP-DB] trouble: joining more than 2 tables

2003-06-19 Thread Blade
Hello, I am having a little trouble with joining more that two tables. I can join two tables but once I start to add more tables to the WHERE clause only two records show up. I am still pretty new to MySQL, but I am learing. I am just stuck on this one in hopes someone will show me the light.

Re: [PHP-DB] Problems with formvalues by using Suse 8.2

2003-06-19 Thread Thorsten Körner
Hi Am Donnerstag, 19. Juni 2003 20:07 schrieb Ruprecht Helms: Hi, under using Suse 8.2 I've the problem that the values of formfields will be put out or worked withit within a phpscript. The testscript with phpinfo() is working fine. What have I to set (in the php.ini) that php is

RE: [PHP-DB] Problems with formvalues by using Suse 8.2

2003-06-19 Thread Gary . Every
To protect yourself by keeping register_globals off but still have access to your GET and POST info, do the following: snip foreach($_POST as $key=$value) { $$key = $value; } // Now all the post vars are in their corresponding key names // You can do the same with $_GET vars /snip Using

[PHP-DB] actualy result of problem with formfieldvalues under Suse 8.2

2003-06-19 Thread Ruprecht Helms
Hi, in the meantime I set the value of register_globals = off the next to on. I get the same result. The following script I use for testing the formfieldvalues ? echo $begriff ? The value I take from a normal formfield by the default transfermethod. After switching to the php-script I get a

Re: [PHP-DB] actualy result of problem with formfieldvalues under Suse 8.2

2003-06-19 Thread Thorsten Krner
Hi Am Donnerstag, 19. Juni 2003 23:21 schrieb Ruprecht Helms: Hi, in the meantime I set the value of register_globals = off the next to on. I get the same result. The following script I use for testing the formfieldvalues ? echo $begriff ? As I said before, this the wrong way. You

[PHP-DB] Two-column display of data, second method

2003-06-19 Thread David Shugarts
When I went looking for a script that would give me a two-column layout that would list my faculty members in two roughly equal columns, alphabetized down the first column and then the second, I did not find such a script. [There was indeed a two-column script, but it fed the data row-by-row.] I

Re: [PHP-DB] actualy result of problem with formfieldvalues underSuse 8.2

2003-06-19 Thread Ruprecht Helms
On Thu, 2003-06-19 at 23:30, Thorsten Körner wrote: Hi Am Donnerstag, 19. Juni 2003 23:21 schrieb Ruprecht Helms: Hi, in the meantime I set the value of register_globals = off the next to on. I get the same result. The following script I use for testing the formfieldvalues ?

Re: [PHP-DB] actualy result of problem with formfieldvalues under Suse 8.2

2003-06-19 Thread Thorsten Krner
HI Am Donnerstag, 19. Juni 2003 23:54 schrieb Ruprecht Helms: On Thu, 2003-06-19 at 23:30, Thorsten Körner wrote: Hi Am Donnerstag, 19. Juni 2003 23:21 schrieb Ruprecht Helms: Hi, in the meantime I set the value of register_globals = off the next to on. I get the same

[PHP-DB] Renaming all pages to .php

2003-06-19 Thread David Blomstrom
I joined this list a few weeks ago because I wanted to learn about php. Unfortunately, I still haven't found time to study it in any depth. Thus, my question might be a bit amateurish, but it's fairly urgent, so I'd appreciate any feedback anyone cares to offer. I'm working on a new website

Re: [PHP-DB] Renaming all pages to .php

2003-06-19 Thread Joshua Stein
I'd like to get some feedback from this forum. Do you agree that a page without php functions or server side includes can be put online with either a .htm or .php function? If I never add a php function to a page with a .php extension, could that cause some kind of problems? it won't cause

RE: [PHP-DB] Renaming all pages to .php

2003-06-19 Thread Mike Brum
You can easily add the .php extension to any .htm(l) page that you have with no worries as long as you have PHP installed and configured properly. The only problem is that page load will be SLIGHTLY slower since PHP will search all .php pages for PHP code to evaluate. Upon finding none, it will

Re: [PHP-DB] Renaming all pages to .php

2003-06-19 Thread David Blomstrom
At 09:16 PM 6/19/2003 -0500, Joshua Stein wrote: it won't cause any problems. you'll have the very small overhead of having to run every static page through php's parser, but if you're going to have php in these pages in the future it doesn't really matter. Also, I'm thinking of naming all