Code Forums - View Single Post - Control table display with php & Postgresql?

Admin · 07-17-2002, 06:59 AM

use SQL like this

first page:
select * from TABLENAME limit 0,10;

second page:
select * from TABLENAME limit 10,10;

third page:
select * from TABLENAME limit 20,10;

i would probaly do something like this in my php:

$start = $start + 10;

pass $start from the first page to all subpages

07-17-2002, 06:59 AM	#2 (permalink)
Admin $_['Your_Mom']; Join Date: May 2002 Location: Santee Posts: 627	use SQL like this first page: select * from TABLENAME limit 0,10; second page: select * from TABLENAME limit 10,10; third page: select * from TABLENAME limit 20,10; i would probaly do something like this in my php: $start = $start + 10; pass $start from the first page to all subpages __________________ Urban Clothing