[PHP-DB] re:[PHP-DB] Splitting Product catalog

2003-06-27 Thread Michael Lewis
Graeme, Use a select string as in, $sel=select * from product where price100 order by price LIMIT 0,100; This would result in the query only returning the first 100 records. If you want to page through them (back and next links). You would have to save the current start point and the length

Re: [PHP-DB] re:[PHP-DB] Splitting Product catalog

2003-06-27 Thread Boa Constructor
(maximum limit) 4-1 = 3 (minimum limit) Would this work? Cheers, Graeme :) - Original Message - From: Michael Lewis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 27, 2003 3:47 PM Subject: [PHP-DB] re:[PHP-DB] Splitting Product catalog Graeme, Use a select string