Mysql error - supplied argument is not a valid MySQL result resource -

this question has answer here:

• how can prevent sql injection in php? 28 answers
• warning: mysql_fetch_array(): supplied argument not valid mysql result 6 answers

i need error:

warning: mysql_fetch_assoc(): supplied argument not valid mysql result resource in *****/log.php on line 15.

here line 15:-

$query = "select count(id) amt users name='$username' password='$password'"; $q = mysql_query($query,$c); $user = mysql_fetch_assoc($q); // line 15 $amt_found = (int)$user['amt']; 

you're missing and

$query = "select count(id) amt users name='$username' , password='$password'"; $q = mysql_query($query,$c); $user = mysql_fetch_assoc($q); // line 15 $amt_found = (int)$user['amt'];