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 Link to comment https://forums.phpfreaks.com/topic/131988-display-the-top-3-speed-timing-excluding-blank-cell/ 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? Link to comment https://forums.phpfreaks.com/topic/131988-display-the-top-3-speed-timing-excluding-blank-cell/#findComment-685837 Share on other sites More sharing options...
sungpeng Posted November 9, 2008 Author Share Posted November 9, 2008 Yes it does Thank Link to comment https://forums.phpfreaks.com/topic/131988-display-the-top-3-speed-timing-excluding-blank-cell/#findComment-685838 Share on other sites More sharing options...
Andy-H Posted November 9, 2008 Share Posted November 9, 2008 No probs Link to comment https://forums.phpfreaks.com/topic/131988-display-the-top-3-speed-timing-excluding-blank-cell/#findComment-685840 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.