RE: [PHP-DB] not a valid MySQL result resource

2003-01-20 Thread John W. Holmes
://www.phparch.com/ > -Original Message- > From: Addison Ellis [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 20, 2003 2:30 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] not a valid MySQL result resource > > hello and thank you for your time. > can you

[PHP-DB] not a valid MySQL result resource

2003-01-20 Thread Addison Ellis
hello and thank you for your time. can you tell me why the below: i think this whole section is line 22 because whatever i change in these first four lines still has the error message point to line 22. $cobj = mysql_db_query($dbname,"select * from category where id=$category"); //line 22 $cro

RE: [PHP-DB] Not a valid MySQL result resource

2001-11-09 Thread matt stewart
e: [PHP-DB] Not a valid MySQL result resource > //.../... first part of the code is to connect to the right DB on a MySQL > server. It works fine > //This code to show the query. It runs well under MySQL and gives 1 result : > $query="SELECT Login, Password FROM `user` WHER

Re: [PHP-DB] Not a valid MySQL result resource

2001-11-08 Thread Miles Thompson
I'd check for mysql_num_rows( $result_query) > 0 as well. It's entirely possible the user mis-typed the login or password values. Miles At 07:26 PM 11/8/01 -0600, Paul DuBois wrote: >At 2:04 AM +0100 11/9/01, MPropre wrote: >>>//.../... first part of the code is to connect to the right DB on a My

Re: [PHP-DB] Not a valid MySQL result resource

2001-11-08 Thread DL Neil
> //.../... first part of the code is to connect to the right DB on a MySQL > server. It works fine > //This code to show the query. It runs well under MySQL and gives 1 result : > $query="SELECT Login, Password FROM `user` WHERE user.login=''$login'' and > user.password=''$password''"; > //This

Re: [PHP-DB] Not a valid MySQL result resource

2001-11-08 Thread Paul DuBois
At 2:04 AM +0100 11/9/01, MPropre wrote: >//.../... first part of the code is to connect to the right DB on a MySQL >server. It works fine > > >//This code to show the query. It runs well under MySQL and gives 1 result : > $query="SELECT Login, Password FROM `user` WHERE user.login=''$login'' and

[PHP-DB] Not a valid MySQL result resource

2001-11-08 Thread MPropre
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]