How to make pagination

hello i need help i was wounding how do i create a pagination for my status system

A true developer

Pagination? Like smilies?

Depends a lot on what kind of pagination you're trying to do. Some methods may take two pages of code while others only need a few lines. Preferably, it should be done in PHP.

Catch my drift.

i no php but how to start it off

A true developer

Explain what kind of page system you're looking for and give an example.

i.e. [1][2] . . . [9][10][>>]

Catch my drift.

Here's a script that I made from scratch:
<?
include("include.php"); //include your database and stuff here

$page=$_GET[page];
if(!$page){
$page=0;
}
$rpp=6;
$s=$page*$rpp;
$q=mysql_query("SELECT * FROM profile LIMIT $s,$rpp");
$count=mysql_num_rows($q);
$pages=ceil($count / $rpp);
$next=$page + 1;
$prev=$page-1;

if($page<$pages){
echo("<a href='/userlist.phtml?page=$next'><img src='/next.png'/></a>");
}
if($page==$pages){
echo("<a href='/userlist.phtml?page=$prev'><img src='/prev.png'/></a>");
}

while($d=mysql_fetch_array($q)){
//run whatever results you want to be displayed here
}
?>

Does this alter-ego make me look stupid?

Urf. Don't use that script; Use this:
<?
$rows=mysql_num_rows(mysql_query("SELECT * FROM mail WHERE from_user='$user'"));
$rpp=8;
$pages = floor($rows / $rpp);
$page=$_GET[page];
if(!($page || is_int($page))){
$page=0;
}
$start=$page*$rpp; //creates the starting point for sorting the data
//die(print($start)); //checks the starting point for sorting the data
$q=mysql_query("SELECT * FROM mail WHERE from_user='$user' ORDER BY id DESC LIMIT $start,$rpp");
$next=$page + 1;
$prev=$page-1;
?>
<!--HTML or whatever goes here-->
<?
if($page<=$pages && $page!=0){
echo("<a href='/mymessageoutbox.phtml?page=$prev'><img src='/prev.png'/></a> | ");
}

if($page<$pages){
echo("<a href='/mymessageoutbox.phtml?page=$next'><img src='/next.png'/></a>");
}

while($md=mysql_fetch_array($q)){
//now run code
}
?>

Does this alter-ego make me look stupid?

i test not working

<?
include("database.php");
$rows=mysql_num_rows(mysql_query("SELECT * FROM status"));
$rpp =8;
$pages = floor($rows/$rpp);
$page=$_GET[page];
if(!($page || is_int($page))){
$page=0;
}
$start=$page*$rpp;
die(print($start));
$q=mysql_query("SELECT * FROM status ORDER BY id DESC LIMIT $start,$rpp");
$next=$page + 1;
$prev=$page-1;
?>
<?
if($page<=$pages && $page=4){
echo("<a href=status2.php?page=".$prev.">U</a>");
}
if($page<$pages){
echo("<a href=status2.php?page=".$next.">U</a>");
}
while($row=mysql_fetch_array($q)){ //now run code
echo"<div class=Body><div class=comment_style><div class='Body'>";
echo"<div class='Avatar_css'><img src='".$row['Avatar']."' width='50' height='50' style='background-color:white;'></div> ";
$txt = mysql_query("SELECT COUNT(comment) FROM status_comment WHERE id1='".$row['id']."'");
$like = mysql_fetch_array($txt);
echo" <font size=2px><a style='float:left;' href=profile.php?username=".$row['username'].">".$row['username']."</a><br><div class=signer>".$row['date']."</div></font><font color='gray'><div style='float:right;' class=signer>Signer:( ".$row['signer'].")</div></font></font></div><div class='comment'>".$row['comment']."</div><font size='3px'><a href='status_comment.php?id1=".$row['id']."'><img src='http://shapeshed.com/images/articles/comment_stage_6.png' width='40' height='10'></a>(".$like['COUNT(comment)'].")</font></div>";
echo"</div></div>";
}
?>







<link href='Status_css.css' rel='stylesheet'></link>

A true developer

ok i now how to make one it simple thank ricky

A true developer

Nice Script =O

.

Who ricky@Red Mist?

A true developer

Both scripts.

.

Thanks Chris..

Does this alter-ego make me look stupid?

You're welcome. This thread seems pretty much resolved, so I'll lock it up now.

.

~Lock

.