nuk3 — Fri, 09 May 2003 11:14:47 +0000

Yep, thats even better. Thanks for that Wired.

Wired — Fri, 09 May 2003 03:06:37 +0000

http://www.devshed.com/Server_Side/PHP/Paginating/page1.html

This does it in PHP. Works like a charm!

boiler — Mon, 05 May 2003 18:18:52 +0000

I had made it under cgi.
you can look on http://www.n1xn0x.bz/?load=proxy
and i think the logic of php and cgi didn't different too much

Mark Hensler — Mon, 05 May 2003 17:02:05 +0000

You can page results in ASP too. No reason to get ASP.NOT.

And if you wanted too, you could write a PHP object to do the same. No reason to submit to the control of the evil empire.

Elemental — Mon, 05 May 2003 08:15:14 +0000

Heh heh... you poor guy. Using ASP.Net. How much did you pay for that, I wonder?

SqlGuru — Sat, 03 May 2003 21:40:03 +0000

Ahh, you poor guys...

In ASP.Net, use a Datagrid

It gives you paging, sorting, all sorts of neat stuff without the hassle.

nuk3 — Sat, 26 Apr 2003 01:53:53 +0000

Thats the sorta thing I was after, thanks Rob.

ROB — Fri, 25 Apr 2003 18:15:29 +0000

here's a quick example

<?php

// records to display per page
$perpage = 10;

// total number of records
list($totalnum) = mysql_fetch_row(mysql_query("SELECT COUNT(*) FROM tablename"));

// figure out page navigation stuff
$numpages = intval($totalnum/$perpage);
if(!$numpages) $numpages = 1;
elseif($totalnum%$perpage) ++$numpages;

$startpage = (int)$_REQUEST['start'];
if(!$startpage) $startpage = 1;

if($startpage > $numpages) $startpage = $numpages;
$start = ($startpage - 1) * $perpage;

$showingstart = $start + 1;
$showingstop = $showingstart + $perpage - 1;
$showingtotal = $totalnum;
if($showingstop > $totalnum) $showingstop = $totalnum;

$results = mysql_query("SELECT * FROM tablename LIMIT $start,$perpage");

?>

<p>Showing records <?=$showingstart;?> - <?=$showingstop;?> of <?=$showingtotal;?></p>
<p>
	<?for($i=0; $i<$numpages; ++$i): ?>
		<a href="thispage.php?start=<?=$i;?>"><?=$i;?></a>
	<?endfor;?>
</p>

<p>
	<!-- show results here -->
	<?while($row = mysql_fetch_assoc($results)): ?>
		blah blah blah
	<?endwhile?>
</p>

nuk3 — Sat, 19 Apr 2003 09:43:34 +0000

Ok thanks Busy, I'll try that

Busy — Sat, 19 Apr 2003 09:41:46 +0000

take a look in hotscripts.com I looked for one a while back but all i found were page length scripts, so created my own that found the total number of items and started displaying 100 at a time, if total number was over 100, add a next button, if not then just add previous and number of results, for page 2 display the results minus 100 (page 1 contents) and do the same check but this time add a previous button