Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given

[shortysbest]

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\ajaxpages\attendance\student_attendance.php on line 7

 

 

<?php $i=1;?>
<?php error_reporting();include("../../connect.php"); session_start();

$class_id = $_POST['class_id'];

$query =  mysql_query("SELECT * FROM attendance WHERE class='$class_id' ORDER BY student ASC ");
while($row = mysql_fetch_array($query))                ####LINE 7<----------------------------------------
{
?>
<li><div class="num"><?php print $i++?></div><?php print $row['student']; ?></li>
<?php }?>

[Pikachu2000]

Your query failed and returned a boolean FALSE.

[shortysbest]

mispelled database column in database. >.< stupid mistake.