When you get that error, it generally means your query failed, or you
have the wrong variable in a mysql_fetch_*() function. Use mysql_error()
to see what the error is if the query failed.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://
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
