RE: [PHP] Additional query for number of records in table

2006-11-17 Thread afan
something new. :) Thanks Ray -afan > Ray > > -Original Message- > From: Brad Bonkoski [mailto:[EMAIL PROTECTED] > Sent: Friday, November 17, 2006 1:57 PM > To: [EMAIL PROTECTED] > Cc: php-general@lists.php.net > Subject: Re: [PHP] Additional query for number of recor

RE: [PHP] Additional query for number of records in table

2006-11-17 Thread Ray Hauge
ubject: Re: [PHP] Additional query for number of records in table [EMAIL PROTECTED] wrote: > hi, > I have query to select products for specific category from DB, something > like: > SELECT prod_id, prod_name,... > FROM products > LIMIT $From, $To > > where $From and $To val

Re: [PHP] Additional query for number of records in table

2006-11-17 Thread afan
> [EMAIL PROTECTED] wrote: >> hi, >> I have query to select products for specific category from DB, something >> like: >> SELECT prod_id, prod_name,... >> FROM products >> LIMIT $From, $To >> >> where $From and $To values depend of on what page you are. let say there >> are 100 products and I'm lis

Re: [PHP] Additional query for number of records in table

2006-11-17 Thread Brad Bonkoski
[EMAIL PROTECTED] wrote: hi, I have query to select products for specific category from DB, something like: SELECT prod_id, prod_name,... FROM products LIMIT $From, $To where $From and $To values depend of on what page you are. let say there are 100 products and I'm listing 25 products per page.