Re: Link only active letters in alphabetical search
| From: | barophobia | Date: | Thu, 08 Jul 2004 18:30:54 +0000 |
| Subject: | Re: Link only active letters in alphabetical search | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-189991@lists.php.net to get a copy of this message | ||
On Thu, 8 Jul 2004 13:14:50 -0500, Jay Blanchard
<jay.blanchard@niicommunications.com> wrote:
> Do it with SQL
>
> SELECT DISTINCT(SUBSTRING(
productName, 1, 1)) FROM
> productTable
>
> will give you only one of each of the starting letters that actually
> occur in your database.
good job. that works great. it's *much* faster now.
thanks!
chris.
p.s. do you use backticks in all your qeuries?