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 Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.