The return value of
mysql_query
is a mixed type. It is a boolen value or a resource upon success for specific query types.
When an error occured, the return value is boolean
false
which probably happened here.
Solution:
Check the return value before fetching results:
if ($query = mysql_query($sql)) {
while ($users=mysql_fetch_assoc($query)){
}
} else {
}