[PHP Multi page script..] -

PHP Multi page script..
Discuss PHP Multi page script..

Posted by: shan

Hey all I gotta question on a script i'm working on....working example is @ [url]http://www.shanb.com/events[/url]

Here's the script
[PHP]
<?
mysql_connect(localhost,'user','pass') or die ("No connection");
mysql_select_db('events') or die ("No database found!");
$query = ("SELECT * FROM pics WHERE picevent = '$pic_event' ORDER by picorder ASC");
$result = mysql_query($query);
$numrows = mysql_num_rows($result);
if($numrows=='0'){
echo "<tr><td colspan='2' align='center'>Sorry, no pictures for this event ( $pic_event )!!</td></tr>\n";
echo "<tr><td colspan='2' align='center'>Maybe I'll put them up sometime...</td></tr>\n";
}

for ($cur = 0; $cur < $numrows; $cur++){
$row = mysql_fetch_array($result);

echo "<tr><td><a href='viewimage.php?picture=$row[picname]' target='_blank'><img width='20%' border=0 src='./$row[picevent]/$row[picname]'></a></td>\n";
echo "<td>$row[piccoments]</td>\n";
echo "</tr>\n";
}
mysql_close();
?>
[/PHP]

What i want to do, is only display 10 pictures per page and have links on the bottom that are like page 1 page 2 page 3 and so on....anyone have any advice....

Posted by: shan

it's ok, i played around and figured it out, so here's what i did if anyone wants to know :) ;)

[PHP]
<?
if ($pg==''){
$pg = 0;
}
$pagestart = ($pg*10);
$pageend = ($pagestart+10);
mysql_connect(localhost,'user','pass') or die ("No connection");
mysql_select_db('events') or die ("No database found!");

$cquery = ("SELECT * FROM pics WHERE picevent = '$pic_event'");
$cresult = mysql_query($cquery);
$cnumrows = ceil(mysql_num_rows($cresult)/10);

$query = ("SELECT * FROM pics WHERE picevent = '$pic_event' ORDER by picorder ASC LIMIT $pagestart,$pageend");
$result = mysql_query($query);
$numrows = mysql_num_rows($result);

if($numrows=='0'){
echo "<tr><td colspan='2' align='center'>Sorry, no pictures for this event ( $pic_event )!!</td></tr>\n";
echo "<tr><td colspan='2' align='center'>Maybe I'll put them up sometime...</td></tr>\n";
}

for ($cur = 0; $cur < $numrows; $cur++){
$row = mysql_fetch_array($result);

echo "<tr><td width='30%'><a href='viewimage.php?picture=$row[picname]' target='_blank'><img width='20%' border=0 src='./$row[picevent]/$row[picname]'></a></td>\n";
echo "<td width='70%'>$row[piccoments]</td>\n";
echo "</tr>\n";
}
echo "<tr><td colspan='2' bgcolor='#FFFFFF' align='center'>";
echo "* <a href='viewpics.php?pic_event=$pic_event'>Start</a> * ";
for ($i = 1 ; $cnumrows > $i ;$i++){
echo "<a href='viewpics.php?pic_event=$pic_event&pg=$i'>Page $i</a> * ";
}
echo "</td></tr>";
echo "</td></tr>";
mysql_close();

?>
[/PHP]