MotoMaster Posted November 8, 2013 Share Posted November 8, 2013 Hi everyone! Im working on a project that i need to implement a results table with pagination. Currently i have it working with a $pos = 1 and a $pos++ But as soon as i change the page the rank starts at 1 again. I have been reading up on it and there seems to be a way to have mysql assign rank in the query. I'm failing to understand the logic. Could someone please help? SELECT * , members.Username, members.city, members.state FROM picks_test INNER JOIN members ON picks_test.user_id = members.user_id ORDER BY picks_test.round_total DESC LIMIT $start, $per_page Thanks Quote Link to comment https://forums.phpfreaks.com/topic/283734-php-mysql-pagination-with-ranking/ Share on other sites More sharing options...
Solution Barand Posted November 8, 2013 Solution Share Posted November 8, 2013 If you are paginating then you will have LIMIT X, Y in your query. Instead of setting $pos = 1, set it to $pos = X+1 Quote Link to comment https://forums.phpfreaks.com/topic/283734-php-mysql-pagination-with-ranking/#findComment-1457596 Share on other sites More sharing options...
MotoMaster Posted November 8, 2013 Author Share Posted November 8, 2013 If you are paginating then you will have LIMIT X, Y in your query. Instead of setting $pos = 1, set it to $pos = X+1 Genius!! Such a great simple solution Cheers Mate! Quote Link to comment https://forums.phpfreaks.com/topic/283734-php-mysql-pagination-with-ranking/#findComment-1457600 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.