Display of Query results Problem

[dweb77]

I posted the query quesiton earlier and this query succesfully works in grabbing the data I need. For some reason the display is only showing one record on the screen instead of 5 (the number assigned to $display). I know the query works as I directly entered it into the mysql database. Any idea why only one record is showing?

 

Thanks for any thoughts.

 

 

 

$query = "SELECT c_save_url.school_id, c_save_url.state_id, c_schools.school_name, c_schools.school_site FROM c_schools LEFT JOIN c_save_url
ON cb_save_url.school_id = c_schools.school_id WHERE user_id = '$user' ORDER BY school_name ASC LIMIT $start, $display";
$sch = mysql_query ($query);



while ($sch = mysql_fetch_array($sch, MYSQL_ASSOC)) {


echo '
<tr>
	<td width="325" height="20">
	<p align="left"><font face="Verdana" size="2">	

	<a href="' . $sch['school_site'] . ' " target="_blank">' . $sch['school_name'] . ' </a>

	</font></td>
	<td width = "45" align="center"><font face="Verdana" size="1">

	<a href="school_body.php?sid=' . $sch['school_id'] . '&spname=' . $sch['sport_id'] . '" target="fr_school_body">INFO</a>

</font>
</td>
<td width = "50" align="center"><font face="Verdana" size="1">

M · <a href="javascript:Save(\'school.php?sid=' . $sch['school_id'] . '&user=' . $user . '&spname=' . $sch['school_id'] . '\',\'height=380,width=300,scrollbars=no\')"\;>R</a>
';

[hitman6003]

Use a code tag around your example...other wise it makes it impossible to tell what is going on with your code.