MORTE 78 Posted October 26, 2014 Share Posted October 26, 2014 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/m2test036/public_html/site/inc/head.inc.php on line 37 help ? head.inc.php <?PHP if(isset($_POST['submit']) && ($_POST['submit']=="login" || $_POST['submit']=="LOGIN" || $_POST['submit']=="Login")) { if(!empty($_POST['userid']) && !empty($_POST['userpass']) && checkAnum($_POST['userid']) && checkAnum($_POST['userpass'])) { $sqlCmd = "SELECT id,login,web_admin,email FROM account.account WHERE login LIKE '".mysql_real_escape_string($_POST['userid'])."' AND password=PASSWORD('".mysql_real_escape_string($_POST['userpass'])."') LIMIT 1"; $sqlQry = mysql_query($sqlCmd,$sqlServ); if(mysql_num_rows($sqlQry)>0) { $getAdmin = mysql_fetch_object($sqlQry); $_SESSION['user_id'] = $getAdmin->id; $_SESSION['user_name'] = $getAdmin->login; $_SESSION['user_admin'] = $getAdmin->web_admin; $_SESSION['user_email'] = $getAdmin->email; $updateIP = mysql_query("UPDATE account.account SET web_ip='".mysql_real_escape_string($_SERVER['REMOTE_ADDR'])."' WHERE id='".mysql_real_escape_string($getAdmin->id)."'",$sqlServ); } } } if(empty($_SESSION['user_id'])) { unset($_SESSION['user_id']); unset($_SESSION['user_name']); unset($_SESSION['user_admin']); unset($_SESSION['user_email']); } else { $sqlCmd = "SELECT id,login,web_admin,email FROM account.account WHERE web_ip='".mysql_real_escape_string($_SERVER['REMOTE_ADDR'])."' AND id='".mysql_real_escape_string($_SESSION['user_id'])."' LIMIT 1"; $sqlQry = mysql_query($sqlCmd,$sqlServ); if(mysql_num_rows($sqlQry)>0) { $getAdmin = mysql_fetch_object($sqlQry); $_SESSION['user_id'] = $getAdmin->id; $_SESSION['user_name'] = $getAdmin->login; $_SESSION['user_admin'] = $getAdmin->web_admin; $_SESSION['user_email'] = $getAdmin->email; } else { unset($_SESSION['user_id']); unset($_SESSION['user_name']); unset($_SESSION['user_admin']); unset($_SESSION['user_email']); } } ?> Link to comment Share on other sites More sharing options...
MORTE 78 Posted October 26, 2014 Author Share Posted October 26, 2014 BUMHP HELPPPPPPPPPP please PLEASEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE Link to comment Share on other sites More sharing options...
Rumor 2603 Posted October 27, 2014 Share Posted October 27, 2014 I'm a little rusty with this but try this out.. Find this: $sqlQry = mysql_query($sqlCmd,$sqlServ); Replace with this: $sqlQry = mysql_query($sqlCmd,$sqlServ) or die(mysql_error()); Do the action again on the website, and a more informative error should appear. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now