JS> What I'm trying to do is have the ability to page through the database just JS> 4 products at a time.
Use the LIMIT clause in your SQL query: select * FROM products WHERE prod_cat = $cat_ID LIMIT 4 For the paging, you would use LIMIT with an offset (starting point) and number of rows, like: page 1: select * FROM products WHERE prod_cat = $cat_ID LIMIT 0,4 page 2: select * FROM products WHERE prod_cat = $cat_ID LIMIT 4,4 page 3: select * FROM products WHERE prod_cat = $cat_ID LIMIT 8,4 and so on. Your links could send the offset as part of the query string, so you just re-run the script and offset is dynamic. - Julie --> Julie Meloni --> [EMAIL PROTECTED] --> www.thickbook.com Find "Sams Teach Yourself MySQL in 24 Hours" at http://www.amazon.com/exec/obidos/ASIN/0672323494/thickbookcom-20 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
