[RESOLVED] Userlist with multiple pages but you are showen the page you are on.

[fr8]

What im trying to do is when my user clicks on the member list. Instead of it just showing the first page. It shows the page that he is on.

So if there is 23 pages and he is on page 5. Then when he clicks on member list I show him page 5 and he can navigate from there.

Varible would be Total rows. and 100 rows per page. I know this is simple math to get the job done but I cant see how to do it in php. Any ideas?

[atokatim]

Not sure if i quite get what you are trying to say, but i am sure you can modify this to whatever you want.

$perpage = 100;
$page=$_GET['page'];
if($page == "" || $page <= 0){ $page = 1; }
$start = ($page - 1) * $perpage;
$end = $start + $perpage;
$nop=mysql_num_rows(mysql_query("SELECT * FROM members")); // modify this to your query
$nop=$nop / $perpage;
$nop = round($nop, 2);
$p = explode(".", $nop);
$pages = $p[0];
if($p[1] > 0){ $pages = $pages + 1; }

if($pages > 1){
		$i=1;
		while($i <= $pages){
			echo ' | <a href="?page='.$i.'">'.$i.'</a>'; // if you are already using ?var=something, change the ? to &
			$i++;
		}
}

[fr8]

That seems inefficient. no offense I do appriciate the help.

But is it possible to use count() or something in a mysql query and have it tell me that user "A" was 530 rows deep. Then divide that into rows per page then use my LIMIT values to show the correct page.

Is something like that possible?

[fr8]

Think about it long enough and it will come to you. 🙂

This is how I got the number of rows deep the user is based on a sorted order.

SELECT Count( * ) AS USERSAHEAD FROM userlist WHERE 1 AND date > $date ORDER BY date DESC

Take that and Add 1 and that is the users exact position.