[SOLVED] Strange error??

[LiamProductions]

Hey.

 

Heres the error:

 

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\wamp\www\MySystem\members.php on line 11

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\MySystem\members.php on line 12

There was a critical error. Matching your data.

 

And heres the code:

<?php



if(isset($_POST['submit'])) {
if(isset($_POST['user'])) {
	if(isset($_POST['pass'])) {
		    include('mysql.php');
			$user = mysql_real_escape_string($_POST['user']);
            $result = mysql_query("SELECT * FROM `system` WHERE `members`.`user` = '$user'");
            $user = mysql_fetch_assoc($result);
            if(mysql_num_rows($result) == 0) {
				echo "There was a critical error. Matching your data.";
			}
			else {
				$enteredPassword = md5($_POST['pass']);
				$pass = ($_POST['pass']);
				if($enteredPassword == $pass) {
					$userC = $_POST['user'];
					setcookie("User", $userC, time()+3600);
				}
				else {
					echo "There was a critical error. Matching your data.";
				}
			}
	}
	else {
		echo "There was a critical error with you <b>Password</b>.";
	}
}
else {
	echo "There was a critical error with your <b>Username</b>.";
}
}
else {
echo "There was a critical error.";
}

?>

 

Its a login file. Can you find the error because i can't.

[cooldude832]

replace

            $result = mysql_query("SELECT * FROM `system` WHERE `members`.`user` = '$user'");

 

with

            $result = mysql_query("SELECT * FROM `system` WHERE `members`.`user` = '$user'") or die(mysql_error());

 

and paste the error in here

[LiamProductions]

Table 'system.system' doesn't exist

 

 

The database is called system and the table with users in is called members.

[LiamProductions]

Fixed!

[cooldude832]

This is just a suggestion, but if a moderator could make this a sticky or a derivation saying you add the or die to a query before posting query issues a lot of problems could be sovled