Re: Supplied argument is not a valid MySQL result resource

What does mysql_query() return? Did you try checking mysql_error()? In order to debug it, a good start would be removing the @ marks from your MySQL statements, so that if there are any errors, you'd see them. Zeev At 17:12 12/4/2001, Joshua Butcher wrote:

I am using code that used to work... I am trying to connect to a database to validate a logon. I get a user ID and password from an HTML file, passed to my PHP script. It fetches the query, but it always returns 1, even if I pass a password that is invalid. The query does not get returned to PHP properly. I had PHP spit out the SQL string it uses and I pasted it into my MySQL administrator and executed it to perfection. I also checked my mysqld.log file and noted that mySQL is in fact executing the query properly when PHP asks it to, and it is executing the proper query, PHP just does not get the proper data back. I know the SQL server is fine, because other databases work, and even other PHP code works, but this snippet won't. I can connect to the CANNON datasbase through Microsoft Access and myODBC, so the data is fine. Any assistance would be greatly appreciated. //CODE BELOW $DB_NAME="CANNON"; $muid="userid"; $mpwd="password"; $server="192.168.1.4"; $DBConn=mysql_connect($server,$muid,$mpwd); echo "<br>[$DBConn]<br>"; @mysql_select_db("CANNON",$DBConn) || DIE("Cannot select Database X"); $uid = $HTTP_POST_VARS["userid"]; $pwd = $HTTP_POST_VARS["password"]; $strSQL="Select UserID,Password From Users Where Active<>0 AND UserID='$uid' AND Password='$pwd'"; $result = @mysql_query("Select * From Users") || DIE ("<br><b>Could not query database...</b>"); $count=@mysql_num_rows($result) || DIE("Could not count records in recordset"); //ERROR HERE if ($count == 0) { $FinalTag="<META HTTP-EQUIV=\"REFRESH\" CONTENT=\"0;URL=login.htm\">"; $x=0; } else { $FinalTag="<META HTTP-EQUIV=\"REFRESH\" CONTENT=\"0;URL=test.php\">"; $x=1; } if ($x==1) { setcookie("PBMGUID",$uid,time()+3600); setcookie("PBMGPWD",$pwd,time()+3600); } echo $FinalTag; //echo $FinalTag; -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net For additional commands, e-mail: php-dev-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

-- Zeev Suraski <zeev@zend.com> CTO & co-founder, Zend Technologies Ltd. http://www.zend.com/