Listing pics and downloads

Tewl

Well im trying to setup the pages for my downloads and screenshots but I dont want php to list them all on one page
i want it to do 10 or so per page. I see these pages with the
"page 1/12 1,2,3,4,5 ->" something along those lines but I have no idea how to code that.
Here is the table I have atm can someone help me

create table screenshots (
sid int(11) not null auto_increment, / id of screenshot /
suser varchar(100), / user that posted /
sfile varchar(100), / screenshot file name/
stitle varchar(100), / title of shot /
scomment text, / comment of shot by user /
spost, / time the shot was posted /
primary key(sid)
);

bivolbg

It' quite a lot of lines. You'd better read a liitle bit !

Tewl

im sure it is and i have been reading but i really have no idea how i would go about it.

bivolbg

the idea:
opendir()
count_items();
$num_of_items;
$pages=(int)$num_of_items/$per_page;
if(!$page) $page=1
$begin=$page$per_page;
if($page==$pages){
$end = $num_of_items -(($pages-1)$per_page)
}else{
$end = $per_page*($page+1);
}
for($i=$begin;$i <$end;$i++)
{
print_item();
}
<a href=next.php?page=<?php print" $page+1"?>">Next </a>

This is a prima vista pseudo code just to get the idea...

coditoergosum

Use a limit in your sql query. Here is a piece of code from one of my sites (http://gagon.net) that uses the same kind of functionality that you're looking for. This script gets posts from a database, posts them, then builds a navigation bar at the bottom of the page using a "previous" and "next" link.


// Set default for begin var
if ($begin == "") { 
$begin = "0"; 
}

// Get total number of rows in the DB and assign to afrows var
$SQL = " SELECT * FROM tablename";
mysql_db_query($db, $SQL, $cid);
$afrows = mysql_affected_rows();

// Select rows from DB to display
$SQL = " SELECT * FROM tablename";
$SQL = $SQL . " ORDER by id desc ";
$SQL = $SQL . " LIMIT $begin,5 ";
$retid = mysql_db_query($db, $SQL, $cid);
$afrows2 = mysql_affected_rows();

// Build navigation
$build_nav = "";

if ($begin != "0") {
$begin_prev = $begin - 5;
$build_nav = $build_nav . "<td align=\"left\"><a href=\"/?begin=$begin_prev\"><< Previous 5</a></td>";
}
$begin_next = $begin + 5;
if ($afrows != $begin_next && $afrows2 > 4) {
$build_nav = $build_nav . "<td align=\"right\"><a href=\"/?begin=$begin_next\">Next 5 >></a></td>";
}

// Display navigation
echo("\n<table cellspacing=\"2\" cellpadding=\"2\" border=\"0\" width=\"400\" align=\"center\">\n\t<tr>\n\t\t");
echo("$build_nav</tr></table>");
}

That isn't the entire script, just the parts that pertain to the navigation links. The importain thing is the limit in the SQL query.

Hope this helps.

Tewl

thanks coditoergosum, I'll try that.