SELECT * FROM table LIMIT 0, 20
LIMIT 20, 20
LIMIT 40, 20
etc
thats doing it with mysql anyways
----- Original Message -----
From: "Vipin Chandran" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 05, 2000 9:46 PM
Subject: [PHP-DB] Database Paging
> Hello,
> I am presently developing a search engine..I would like to have a script
for
> paging through my database results...like "displaying 1 to 20 of 300
> matches" and so on..
>
> All help shall be appreciated,
> Thanx in adv..
> vipin
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]