display the top 3 speed timing excluding blank cell

[sungpeng]

<?php

$sql = mysql_query("SELECT * FROM users order by allstyle400 ASC LIMIT 0, 3");
while($doing=mysql_fetch_array($sql)){
if($doing[allstyle400]!=""){
echo "<br/>NAME : $doing[email] speed : $doing[allstyle400] mins";

}
}

?>

 

Hi, I need to display the top 3 lowest speed timing excluding blank cell. But it display the top 3 blank cell as blank is the lowest numbers. Pls help. Thank

[Andy-H]

<?php

$sql = mysql_query("SELECT * FROM users WHERE allstyle400 != "" order by allstyle400 ASC LIMIT 3");

while($doing=mysql_fetch_assoc($sql)){

   echo "<br/>NAME : $doing[email] speed : $doing[allstyle400] mins";

}

?>

 

Does that work?

[sungpeng]

Yes it does

 

Thank

[Andy-H]

No probs