Hi!
I have a (probably simple) question:
Is the following correct if i want to display an x amount of records based upon a users entry when a category is chosen (say 'Nature'), displaying 10 items per page:
SELECT * FROM maintable WHERE cat_id='$cat' AND description LIKE '%$keyword%' ORDER BY id,description LIMIT $start, $limiet
Then display the number of results ($limiet), increment $start with 10, and do the statement again?
Help is really appreciated!
Fish
