start loop at certain record number

[condoug]

hi all

How do you start a mysql query loop to begin at a certain record instead of the first record in the recordset?

I.e. get it to start from the 3rd record??

Ta

[Shrike]

Strictly speaking you should amend your SQL to only return the rows that you need. If that's absolutely not possible you can use [MAN]mysql_data_seek[/MAN].

[jkurrle]

You could also use a LIMIT statement, to extract a certain subset of rows. Something like this:

SELECT * FROM SomeTable
LIMIT 3,5; <=== meaning start at row 3 and return 5 rows.

Remember that the first row is actually row 0, so the above statement would actually be returning results starting at the 4th row...