Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199908

Re: [PHP3] limiting records displayed From: Alan Morey (amorey <email protected>)
Date: 08/27/99

You can use Limit and offset to limit records displayed
example:
mysql_query("select * from mytable limit $offset, 10");

The $offset should be 0 for first 10 results)
Then $offset should be incremented $offset + 10.

hope this helps
alan

"Ben O'Shea" <roady <email protected>> wrote in message news:19990827142821.A15045 <email protected>
> Hi all,
> How would i go about limiting the number of products displayed per page.
> i.e. i have a select that returns 100 rows, and i want to display 10 rows
> per page making a total of 10 pages....
>
> thanks....
>
>
> --
> Ben O'Shea
>
> --
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to php3-unsubscribe <email protected>
> To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
> To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail: php-list-admin <email protected>
> 

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>