sungpeng Posted November 9, 2008 Share Posted November 9, 2008 <?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 Quote Link to comment Share on other sites More sharing options...
Andy-H Posted November 9, 2008 Share Posted November 9, 2008 <?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? Quote Link to comment Share on other sites More sharing options...
sungpeng Posted November 9, 2008 Author Share Posted November 9, 2008 Yes it does Thank Quote Link to comment Share on other sites More sharing options...
Andy-H Posted November 9, 2008 Share Posted November 9, 2008 No probs Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.