you can use 'limit x,y' in MySql.
James Crowley wrote:
> Hi,
> I want to spread the results of a recordset over a number of pages. In ASP,
> I would have opened a connection with a client-side cursor... but with PHP
> (using it's ODBC functions), it only seems to be able to execute an SQL
> statement, and return all the results... which isn't very efficient if I
> have 500 results with 10 per page!
> Also, how do I change the cursor location?
>
> Regards,
>
> - James
>
> Editor, VB Web
> ==================
> Web - http://www.vbweb.co.uk
> Email - [EMAIL PROTECTED]
> ICQ# - 60612011
> ==================
>
>
--
PHP General 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]
