Jump to content

display the top 3 speed timing excluding blank cell


sungpeng

Recommended Posts

<?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

<?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?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.