://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
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
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
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
> //.../... 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
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 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]