Paging Records? 2

[seagoing]

Re: Win XP Pro IIS5.1 PHP5 MySQL5.

New to PHP/MySQL. Normally develop in ASP, MS Access/SQL
Something I frequently find myself doing in ASP is displaying paged data, from a database, on a webpage, by using the ADO Recordset object. I've not seen an obvious way to do this in PHP with data from a MySQL database, there doesn't seem to be any similar Recordset type object here.

Can anyone point me to a good tutorial on the subject, or perhaps giv an insight into how such functionality is handle on a web page using PHP with data from MySQL?

Regards
TS

 

[TonyGroves]

Do you mean displaying a set of records a page at a time? You can get a subset of the result set using the LIMIT clause:
[tt]
SELECT * FROM tbl
ORDER BY id
LIMIT 100,50
[/tt]
This example will skip the first 100 records and return the next 50.

 

[seagoing]

OK Tony, thanks for that, looks like a promising start.
Regards
TS

 

[guelphdad]

For a php/mysql solution something like this should help.

 

[sleipnir214]

As this is a PHP question in the Tek-Tips site, you might try a FAQ in the PHP forum: faq434-5244



Want the best answers? Ask the best questions! TANSTAAFL!