Hi!
I have a select statement in 1 of my scripts which goes as follows:
SELECT * FROM maintable WHERE description LIKE '%$keyword%' AND cat_id=$catid ORDER BY id, description LIMIT $start, $limiet;
(where $start= for instance 0 and $limiet=10)
So 10 records are read from the database at $start=0 and then ordered? How does MySQL handle then next 10 records when $start=10.
What i am trying to say is this: If i have say 65 records which match the keyword, would the upper line of code do the trick when the $start offset is incremented by 10? (including a previous and next routine somewhere there)
I think i need to know in what way exactly MySQL handles this, and in what order.
Fish
