[snip] currently each letter is hyper linked but i'd like to only link the letters that have an occurrence in the database. in other words, if there are no products in the database that start with the letter 'Z' then i don't want it to have a hyper link. [/snip]
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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
