|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2003-11-03 18:54 UTC] sniper@php.net
[2003-11-17 18:16 UTC] sniper@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Nov 22 19:00:01 2025 UTC |
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"