faqts : Computers : Programming : Languages : PHP : Common Problems : Forms and User Input

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

74 of 95 people (78%) answered Yes
Recently 7 of 10 people (70%) answered Yes

Entry

When using LIMIT in MySQL how can I tell PHP where to start browsing the next page when user hits 'more'?

May 7th, 2004 15:03
Narendra Jain, Wyatt James,


The select statement has the limit clause of the form below:
limit start_row_no, total_count
so the query would look like:
select * from table1
limit 45,15
meaning that you would start at row 45 and get 15 rows.