ID: 26088 Updated by: [EMAIL PROTECTED] Reported By: nathan_jackson at iprimus dot com dot au -Status: Open +Status: Feedback Bug Type: MySQL related Operating System: Windows XP PHP Version: 4.3.3 New Comment:
Try adding 'echo mysql_error();' and 'var_dump($data);' after the mysql_query() call. Previous Comments: ------------------------------------------------------------------------ [2003-11-02 19:54:54] nathan_jackson at iprimus dot com dot au Description: ------------ I am trying to login a user. I want to get the users name and account type from the database the store them in a cookie. I am recieving this message when I try to run the script: "Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\Project\Music Manager\check_login.php on line 14" I am using IIS on Windows XP. Reproduce code: --------------- $password = crypt($HTTP_POST_VARS["password"]); $connec = mysql_connect("localhost", "root", "farmer01"); mysql_select_db("onlinedb"); $data = mysql_query( "SELECT username, name_first, name_last, acc_type FROM user WHERE username = ".$HTTP_POST_VARS['username']." AND password = ".$password.""); If (!$data){ header("Location: /err_login.php"); } else { $row = mysql_fetch_object($data); $values = "".$row->username."|".$row->name_first. "|".$row->name_last."|".$row->acc_type.""; setcookie( "user", $values ); } mysql_close($connec); Expected result: ---------------- I was expecting that all of the values above would have been placed into the cookies "user"as a string. To later be seperated by the explode() function. Actual result: -------------- I recieved this message: "Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\Project\...\check_login.php on line 14" ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=26088&edit=1