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

2001-11-09 Thread matt stewart
] Not a valid MySQL result resource ?php //.../... 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

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: ?php //.../... 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

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

2001-11-08 Thread DL Neil
?php //.../... 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 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: ?php //.../... first part of the code is to connect to the right DB on a