Empty Result Set error

[Anon]

In the following code which tests to see whether a returned recordset is empty or not and performs different actions depending on the result, I find I am dropping ercords when a non-empty set is returned. I have been over and over it and cannot for the life of me see where the problem is. I have had a look at he solutions for such a scenario in this forum and my code seems to be the same, but obviously can't be. If anyone else can pick up the error then great.

if ( $row = mysql_fetch_array($result) ) {

echo(" <TABLE> etc.... ");
while ( $row = mysql_fetch_array($result) ) {
$record_id = $row["record_id"];
$community = $row["community"];
$region = $row["region"];
$psition = $row["psition"];
$application_close = $row["application_close"];
echo(" Records get displayed here ");
}
echo("</TABLE>");
}
else {
echo("<p><FONT SIZE='-1' FACE='Arial'>There are currently no records.</font></p>");
}

[Anon]

You're dropping the first result, obviously enough - you set the value of $row to the first result, and if it's nonempty, you immediately set it again to the second.

I don't know why this idiom is used so often. I generally use:

$result_rows=mysql_num_rows($result);
if($result_rows!=0)
{
echo "<table>...";
for($i=0;$i<$result_rows;++$i){
$row=mysql_fetch_array($result);
...
}
}

The for loop can be replaced by the same old while() loop as before if ypu wish.

[Anon]

Thanks, um, Grumbler. It's going fine now.