I'm working on a directory script, that is going to display from the top referrers on down, but also need it to display in order of status.. This isn't that hard, but then I get into the pagination for the number of pages, and if any were displayed on the previous page/status then seems like it would skip some rows in the db, like say if you display on the previous page the status 4 then like 3 were status 3 then you jump to page 2 and use something like
<?php
$page = (is_numeric($_GET['page'])) ? $_GET['page'] : 1;
$limit = 10;
$from = ($limit * $page) - $limit
//Then Added the LIMIT $from, $limit to the query
?>
So what would be the best way to go about something like that..
Example..
ID | Name | referIn | Status
1 -----bob -----768----- 4
2----- bill----- 34-----3
3-----jan-----900-----3
5 -----ian-----12----- 2
6 -----ken-----560-----4
And so on.
Haven't gotten around to writing this part up yet, was just thinking of ways to do it..
Would want the referIn to descend as well as the status.
Oh yeah New here, so HI! 😃
