Seperate Pages

sgray

heyas,

Ive got a DB which is starting to get a little large. As I dump all of the data from the mysql DB into an html table, the html page size has swelled to over 100kb. What I intend on doing is breaking the pages up into pages of around 100 results. At the moment there are 250 records and with the field names name, comments, user, cds, and date. Can anyone suggest the easiest way to go about implementing some sort of system in which only the first 100 results will get displayed. With that, itd be nice to generate a link to page 2, 3, 4 etc when there were more than that page numbers result.

Any comments, sugestions would be appreciated.

Thanks,

Stewart

hessian

<?
if(empty($start))
$start = 0;

$sql = "SELECT count(column_Name) as total from blah";
$res = mysql_db_query("DB", $sql);
$count = mysql_fetch_object($res);
$pages = ceil($count->total / 100);
for($i = 1; $i < $pages+1; $i++)
{
if($i != 1)
{
echo " | ";
}
echo "<a href=\"$PHP_SELF?$QUERY_STRING&start=" . $i 100 . "\">$i</a>";
}
$sql = "SELECT FROM blah limit $start, 100";
blah... blah.. blah..

sgray

Thanks a lot hessian, ill have a play with that code and let you know how I got on 🙂

sgray

<?
if(empty($start))
$start = 0;

Hey there: My code is as follows

<?
if(empty($start))
$start = 0;

$db = mysql_connect('localhost','user','pass');
mysql_select_db("db", $db);

$select = "SELECT count(name) as total from divx";
$res = mysql_db_query("DB", $select);
$count = mysql_fetch_object($res);
$pages = ceil($count->total / 100);
for($i = 1; $i < $pages+1; $i++)
{
if($i != 1)
{
echo " | ";
}
echo "<a href=\"$PHP_SELF?$QUERY_STRING&start=" . $i 100 . "\">$i</a>";
}
$sql = "SELECT FROM divx".(isset($sort) ? " ORDER BY $sort;" : " ORDER BY name;" limit $start, 100);

Im getting parse errors on the 'echo "<a href=\"$PHP_SELF?$.....' line. Can you see something wrong?

Cheers