Displaying a set number of records

[Rulkster]

i am building my own store and already have a database set up where i can add categories, subcategories and products. Each product has a field for category and subcategory-

ex.
product_name - Indiana Jones
category_name - movies
subcategory_name - action

when i do my sql statement
$qString="Select * from product_table where category=\"movies\" && subcategorey = \"action\" ";

if this search returns 30 matches, i would only like to display 9, then have the user click a next button to display the next 9, and so forth..

Can someone please point me in the right direction on how to accomplish this please

Thank you

[merkinmuffley]

you could register the search results in the session, to begin with. Start with a page that displays all the results from the session. then, add a parameter for that page that controls which result index to begin at (1, 10, 20, etc) and show results from that index and the following 9. Put buttons on the page that request the same page, but with different starting indexes.

See managing data in the session from the PHP manual.

[elfynmcb]

Hey,

If you just stick 'LIMIT 1,9' on the end of your sql query an this will request 1 - 9 queries. Just store the current maximum (9) in the query string and increment or decrement as neccesary...

Hope this helps...

[jayant]

LIMIT 0,9 is the correct thing, LIMIT 1,9 will skip the first result.

Moreover, you will need to use count(*) for getting total number of search results so you can span pages like Page 1, Page 2,3,4,........

[devarticles]

try reading this article, http://www.devarticles.com/content.php?articleId=110&page=1