Hi!
I can't seem to get the logic in the following (fairly new to php)
If i state something like this:
SELECT * from maintable where description like '%$keyword%' AND cat_id=$cid LIMIT $start, $limiet // where $start=0 and $limiet=10
I would get 10 results from the database and display them.
Using Previous and Next pagination, if Next is clicked, what happens then?
The array does not hold more than 10 items! So i will have to retrieve 10 more using a query right?
But how can i retrieve 10 new items from the database to display without the query selecting the same items again? Since the first 10 items are probably not the first 10 in the database!
Can i also select everything like the statement above only without the LIMIT?
And then get the first 10 out of the array?
It seems to me that then i can skip the first 10 items and display the next 10
Any help would really be appreciated!
Fish
