PHP/MySQL solution to this conundrum
Posted: Thu Jan 20, 2005 12:49 pm
Hi there,
I have a list of products recorded in a database.
I have a query which returns a certain number of those products that match those specifications.
However, I only wants lines 10-20 of the return on the query. Is there any addition to the query, or a PHP method other than inefficient for() or while() loops, to jump to line 10 and only cycle to line 20?
Would LIMIT be useful?
(by the way in database speak I guess line should say 'row')
Many thanks
Mark
I have a list of products recorded in a database.
I have a query which returns a certain number of those products that match those specifications.
However, I only wants lines 10-20 of the return on the query. Is there any addition to the query, or a PHP method other than inefficient for() or while() loops, to jump to line 10 and only cycle to line 20?
Would LIMIT be useful?
(by the way in database speak I guess line should say 'row')
Many thanks
Mark