herghost Posted November 2, 2009 Share Posted November 2, 2009 Hi all, I am trying to display the top 10 results from a database but I am not sure how LIMIT works? This is what I have but it does not display anything: $query = "SELECT * FROM users_stocks WHERE user_id = $userid ORDER BY users_total DESC LIMIT 0, 10"; Many Thanks Link to comment https://forums.phpfreaks.com/topic/179955-solved-correct-way-to-use-limit/ Share on other sites More sharing options...
herghost Posted November 2, 2009 Author Share Posted November 2, 2009 nevermind, it really does help if you echo out your query Link to comment https://forums.phpfreaks.com/topic/179955-solved-correct-way-to-use-limit/#findComment-949312 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.