loop not working

[Anon]

Can anyone see why this isn't working. It loops correctly through the number of results returned by the query, and gets the data correctly for the first row, but each subsequent row has the first rows data.

	// Get Assy Data
	//Run the query
$assy_query = "SELECT * FROM trialAssys WHERE unitno='$unitno' AND deleted='NO' ORDER BY Assyname ";
$assy_result = mysql_query($assy_query);
  $num_assys = mysql_num_rows($assy_result);
	$row = mysql_fetch_array($assy_result);
	echo "<table width=\"610\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" align=\"center\">";
	echo "<tr><th colspan=\"5\">&nbsp;Assy Data </th></tr>";
	for ($i=0; $i<$num_assys; $i++)
	{
  	echo "<tr>";
   	 echo "<td class=\"th\" width=\"150\">Assy Name:</td>";
   	 echo "<td class=\"td\" width=\"150\">";
		 echo ($row["assyname"]);
		 echo "</td>";
   	 echo "<td width=\"10\">&nbsp;$rowassy</td>";
   	 echo "<td class=\"th\" width=\"150\">Assy No:</td>";
   	 echo "<td class=\"td\" width=\"150\">";
		 echo($row["assyno"]);
 		echo "</tr>";
	}
	echo "</table>";

[sp0rk]

You only ask for the first row. $row will never hold anything but the first returned row.

Use a while-loop instead. Something like this will give you all the returned rows.

$assy_query = "SELECT * FROM trialAssys WHERE unitno='$unitno' AND deleted='NO' ORDER BY Assyname";
$assy_result = mysql_query($assy_query);
while($row = mysql_fetch_array($assy_result, MYSQL_ASSOC)) {
// more code here
}