[SOLVED] 2 simple sql errors

[ram4nd]

Can anybody tel me that why am i getting these errors:

 

Errors:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /opt/lampp/htdocs/PTC/login.php on line 9

Warning: mysql_num_rows() expects parameter 1 to be resource, null given in /opt/lampp/htdocs/PTC/login.php on line 10

 

Code:

mysql_connect('localhost','something','else');
mysql_select_db('PTC');

$a = 'SELECT id FROM members WHERE user = '.clean($_POST['user']).' AND pass = '.md5($_POST['pass']);
$b = mysql_query($a);
$query = mysql_fetch_array($b);
if(mysql_num_rows($query) == 1) {
        $_SESSION['user'] = $query['id'];
        setcookie('user', $query['id'], (60 * 60 * 24 * 30 + $_SERVER['REQUEST_TIME']));

        header('Location: members.php');
}
else $x = 'Incorrect username or password.';

[Zane]

$b = mysql_query($a) or die("Query: $a

" . mysql_error());

[ram4nd]

Query: SELECT id FROM members WHERE user=ram4nd AND pass=2f951cd95999b19a22fbc1037e552336

Unknown column 'ram4nd' in 'where clause'

[corbin]

It's assuming it's a column name since it's not in quotes.  (I suggest using single quotes around it.)

[ram4nd]

Warning: mysql_num_rows() expects parameter 1 to be resource, array given in /opt/lampp/htdocs/PTC/login.php on line 10

 

$a = 'SELECT id FROM members WHERE user=\''.clean($_POST['user']).'\' AND pass=md5('.$_POST['pass'].')';

[ram4nd]

I had mysql_fetch_array in mysql_num_rows.