Re: Link only active letters in alphabetical search
| From: | Matt M. | Date: | Thu, 08 Jul 2004 18:16:33 +0000 |
| Subject: | Re: Link only active letters in alphabetical search | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-189989@lists.php.net to get a copy of this message | ||
> 1. pull a list of products from the database
> 2. truncate each product id down to it's first letter
> 3. remove all the duplicates
> 4. use this list to build the links.
I would let sql do some of the work.
select count(*) from products where product_name like 'A%'
if count does not return 0 you have products that start with A