-
Can't get this error...
Warning: Wrong parameter count for mysql_result() in /home/djstop/public_html/test/phatfx.php on line 252
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/djstop/public_html/test/phatfx.php on line 254
PHP Code:
case "admin_login" :
myconnect();
$query = "SELECT * FROM `members` WHERE `username` = '$username' AND `password` = '$password' LIMIT 1";
$result = mysql_result($query);
if (mysql_num_rows($result) == 0) {
echo "<center>Sorry, Username and password do not match. Being redirected to main page.</center>";
?>
///////////////////////////////
<?
} else {
session_start();
session_register(username);
session_register(password);
echo "<center>You were logged in successfully, Being redirected to the admin section!</center>";
?>
<meta http-equiv="REFRESH" content="0; url=phatfx.php?action=admin_loggedin" target="_self">
<?
}
myclose();
break;
With that, I get the 2 errors I posten in the top of this thread. Can someone please help me? Thanks!
-
You need to change it to "mysql_query" not mysql_result:
PHP Code:
case "admin_login" :
myconnect(); //I don't know what this is??
$query = "SELECT * FROM `members` WHERE `username` = '$username' AND `password` = '$password' LIMIT 1";
$result = mysql_query($query);
if (mysql_num_rows($result) == 0) {
and also, you don't need the `around table and field names:
PHP Code:
case "admin_login" :
myconnect(); //I don't know what this is??
$query = "SELECT * FROM members WHERE username='$username' AND password='$password' LIMIT 1";
$result = mysql_query($query);
if (mysql_num_rows($result) == 0) {