Paging with PostgreSQL is super easy! select * from table where (x=y) offset 0 limit 30; Gives you the first 30 matches, then do select * from table where (x=y) offset 30 limit 30; This will give the next 30, super easy! Here's a sample of how I use it in a script // Collect offset $offset = isset($_GET['offset'])?$_GET['offset']:0; // Now the links for Prev/Next if ($offset >= 30) echo "|<a href='/contents.php?".$qs."offset=".($offset-30)."'>Back 30</a>"; echo "|<a href='/contents.php?".$qs."offset=".($offset+30)."'>Next 30</a>"; // Query $rs = pg_exec($db,"select id,name from stuff order by name offset $offset limit 30;"); /B ----- Original Message ----- From: "Lynna Landstreet" <lynna@xxxxxxxxxxxxx> To: <pgsql-php@xxxxxxxxxxxxxx> Sent: Friday, August 08, 2003 13:30 Subject: [PHP] Paging results > HI there, > > Thanks to everyone who helped with my keyword problem - I think I thanked > them all individually but I thought I should mention it here too. > > Now, a new question: > > Does anyone know if there's a PHP class anywhere out there for paging > results from a PostgreSQL query, similar to Paginator or ezResults which do > that for MySQL? Or do I have to do the code for that from scratch? > > Alternatively, would it be difficult to adapt one of those to working with > PostgreSQL instead of MySQL? > > > Lynna > -- > Resource Centre Database Coordinator > Gallery 44 > www.gallery44.org > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
