Me da un error y no se que hacer:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dbeach/public_html/php/php/login.php on line 29
El codigo es:
Código PHP:
@ $db=mysql_connect ("localhost", "db_w", "r");
if (!$db){
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db ("db_d");
if ($HTTP_POST_VARS['Ingresar']!=""){
$query = "Select * From Registration where username ='".$username."'";
//echo $query;
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$dbpassword = $row["password"];
if ($dbpassword == $password){
session_register("session_username");
$session_username = $username;
session_register("session_email");
$session_email = $row["Email"];
echo " <script>document.location.href='/php/menu.php'</script>";
}else{
....
Reviso la BD y el ususrio y password que meto si existen el la BD!
Que hago?