Re: [PHP-DB] ODBTP, a possible solution for MS-SQL and other databases

2002-11-02 Thread Rasmus Lerdorf
Sounds interesting. Perhaps toss it into PEAR/PECL and see if anybody is interested in pitching in with maintenance. You never know, someone might pop up and add a bunch of improvements that will benefit you directly. -Rasmus On Sat, 2 Nov 2002, Robert Twitty wrote: Hello I have been using

Re: [PHP-DB] Re: Performance problems?

2002-11-02 Thread Manuel Lemos
Hello, On 11/02/2002 04:04 AM, Leif K-Brooks wrote: Aha - thanks. The problem is, I also need to retrieve other data asscociated with it. I'll alter the table to order by id, but is there anything long-term I can do? What I meant is that if you make two queries, one to fetch max(id) and

RE: [PHP-DB] Performance problems?

2002-11-02 Thread John W. Holmes
What's the structure of your database table? Whofor and id should have indexes on them to speed up queries like this. ---John Holmes... -Original Message- From: Leif K-Brooks [mailto:eurleif;buyer-brokerage.com] Sent: Saturday, November 02, 2002 1:21 AM To: [EMAIL PROTECTED]

[PHP-DB] mysql_connect problem rh7.3

2002-11-02 Thread Wouter
Hello, I've a rather complete php install on redhat 7.3, yet I cant't get php to connect to mysql. I get: Fatal error: Call to undefined function: mysql_connect() in ... It seems that the necessary packages are installed: [root@axon ~]# rpm -qa | grep php php-4.1.2-7.3.4

Re: [PHP-DB] Re: ODBTP, a possible solution for MS-SQL and other databases

2002-11-02 Thread Robert Twitty
Thanks for the tip. I will take this issue to the PHP-DEV list. -- bob - Original Message - From: l0t3k [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 02, 2002 2:31 AM Subject: [PHP-DB] Re: ODBTP, a possible solution for MS-SQL and other databases Robert, this

Re: [PHP-DB] mysql_connect problem rh7.3

2002-11-02 Thread Micah Stevens
It doesn't appear you have the PHP MySQL functions installed. When you run phpinfo() you should get something like: mysql MySQL Supportenabled Active Persistent Links1 Active Links1 Client API version3.23.39 MYSQL_MODULE_TYPEbuiltin MYSQL_SOCKET/var/lib/mysql/mysql.sock MYSQL_INCLUDE MYSQL_LIBS

Re: [PHP-DB] mysql_connect problem rh7.3

2002-11-02 Thread John Coder
While Micah is correct, you do have mysql support on php but as a dbs not the built in php fuctions. Therefore you must use the dbx functions instead. John Coder On Sat, 2002-11-02 at 14:35, Micah Stevens wrote: It doesn't appear you have the PHP MySQL functions installed. When you run

[PHP-DB] Infinite Loop?

2002-11-02 Thread Graeme McLaren
Greetings list members. I've written the code below as part of an automatic email script. The problem with this is it seems to run in to an infinite loop. The for loop seems to get completely ignored by emails get sent constantly. I deleted the script after receiving 2500 emails ! :'( Can

Re: [PHP-DB] Infinite Loop?

2002-11-02 Thread Tony S. Wu
I've seen no way to get out of the while loop. Tony S. Wu [EMAIL PROTECTED] Nope, this world ain't perfect. But at least I know it's not because of me. Graeme McLaren at [EMAIL PROTECTED] wrote: Greetings list members. I've written the code below as part of an automatic email script. The

Re: [PHP-DB] Infinite Loop?

2002-11-02 Thread Jason Wong
On Sunday 03 November 2002 04:26, Graeme McLaren wrote: Greetings list members. I've written the code below as part of an automatic email script. The problem with this is it seems to run in to an infinite loop. The for loop seems to get completely ignored by emails get sent constantly. I

Re: [PHP-DB] Infinite Loop?

2002-11-02 Thread Graeme McLaren
Ah right, I thought that once the while loop condition is true it would execute the for loop then quit once the for loop had reached its condition. But really, whats happening is the while loop is continuing to run the for loop and then run through the while loop again. Ok I've got it now.

[PHP-DB] boolean instead of array

2002-11-02 Thread John Coder
I seem to somehow get an boolean instead of an array from a mysql_fetch_row function and I have no idea how. Here's the code; ? snip $names=mysql_query(select name from dept join picdata where dept.deptid=picdata.deptid limit 5); print $names.p; //offending query snip

[PHP-DB] boolean instead of array update

2002-11-02 Thread John Coder
the deptid in both Tmp and picdata are the same so it nakes no diff which I use the output is the same Boolean each time I just noticed that the tables were diff names but data and structure is the same. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] boolean instead of array

2002-11-02 Thread Jason Wong
On Sunday 03 November 2002 10:23, John Coder wrote: I seem to somehow get an boolean instead of an array from a mysql_fetch_row function and I have no idea how. Here's the code; Try adding some error checking into your code (see manual examples) and using mysql_error() to find out what's