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 Link to comment https://forums.phpfreaks.com/topic/283734-php-mysql-pagination-with-ranking/ Share on other sites More sharing options...
Barand Posted November 8, 2013 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 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! 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
Archived
This topic is now archived and is closed to further replies.