Problems with mysql_fetch_array

Question

So i'm having trouble using mysql_fetch_array. this is my code:

$sql=mysql_query("SELECT * FROM members WHERE group='$group'");
$query=mysql_fetch_array($sql);

i am getting the following error:

Warning: mysql_fetch_array() expects parameter 1 to be resource

Any help would be very appricated

Answer 1

group is a mysql function, you must enclose it with ` so mysql know that it's a name and not the function. like this:

$sql=mysql_query("SELECT * FROM members WHERE `group`='$group'");
$query=mysql_fetch_array($sql);