WHILE() Loop Killing My Formatting - HELP!

[mrhinman]

I've got this page that pulls from the table and shows real estate listings. It displays the listings fine, but once the while loop is over the HTML quits and the rest of the page doesn't show. Am I overlooking something extremely obvious here?

<?
$query = "SELECT * FROM listings WHERE category = '1' and active='y'";
$result = mysql_query($query) or die ("Could not get listings. Contact webmaster.");
while ($rows = mysql_fetch_assoc($result) or die ("Could not show listings. Contact webmaster."))
{
@extract($rows);
?>
<table>
<tr>
<td colspan="2">Location:<font size="+1" color="#FF9900"><? echo "$address, $city";?></font></td>
</tr>
<tr>
<td colspan="2">Acres: <B><? echo "$acres"; ?></B>&nbsp;&nbsp;&nbsp;&nbsp;Square Feet: <B><? echo "$sqfeet"; ?></B></td>
</tr>
<tr>
<td><img src="thumbs/<? echo "$photo"; ?>" border="0"/><BR /><form action="image.php" method="post"><input type="hidden" name="listid" value="<? echo $listid; ?>" /><input type="submit" name="submit" value="Click For Larger Image" class="style1" /></form></td>
<td width="505"><? echo "$description"; ?></td>
</tr>
</table>
<HR />
<? } ?>

The HTML quits right after displaying the <HR>, although I have lots more HTML after this. Any ideas?

[devinemke]

look closely at this line:

while ($rows = mysql_fetch_assoc($result) or die ("Could not show listings. Contact webmaster."))

what you are saying is that as soon as the expression equals boolean FALSE then the script should [man]die[/man]. when the loop reaches the last row then that is exactly what will happen. the [man]die[/man] function does exactly as the it's name suggests: it kills the script execution and no more output is sent.