[RESOLVED] select with comparison operator on int field

[apollyonus]

Have been kicking this one around since school this morning. Have been going through the forums here and a couple other tutorials for the past few hours, but this topic doesn't seem to be very popular.

I'm trying to pull data into an array from a table where a field has an int value greater than x. So here's my query:

 $result = mysql_query("SELECT * FROM $dbtable WHERE jumps > 20");
$row = mysql_fetch_assoc($result);
print("<table border=\"1\" cellpadding=\"5\" cellspacing=\"0\">");
while($row = mysql_fetch_assoc($result)) {
        echo "<tr>\n<td>" . $row['fname'] . "</td><td>" . $row['lname'] . "</td><td>" . $row['jumps'] . "</td><td>" .$row['sk
ill'] . "</td>\n</tr>\n";
}
echo "</table>\n";

It finds the first three matching rows, but the last one is never echoed. so... !? any suggestions or input would be appreciated.

[Installer]

More likely the first one is never echoed. You fetch the first row, but don't do anything with it. Try this:

$result = mysql_query("SELECT * FROM $dbtable WHERE jumps > 20"); 
print("<table border=\"1\" cellpadding=\"5\" cellspacing=\"0\">"); 
while($row = mysql_fetch_assoc($result)) { 
        echo "<tr>\n<td>" . $row['fname'] . "</td><td>" . $row['lname'] . "</td><td>" . $row['jumps'] . "</td><td>" .$row['sk 
ill'] . "</td>\n</tr>\n"; 
} 
echo "</table>\n";

[apollyonus]

Super sweet! (and fast too) thanks much!