On Thu, 8 Jul 2004 13:14:50 -0500, Jay Blanchard <[EMAIL PROTECTED]> 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? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
