Not sure this will work and I wont try right now... SELECT * FROM $table WHERE SUBSTRING(FIELD_WITH_NAMES,0,1) = '$letter' ORDER BY FIELD_WITH_NAMES... You could always try I guess, but I really don't think it would work... "Awlad Hussain" <[EMAIL PROTECTED]> skrev i meddelandet news:[EMAIL PROTECTED] How i do create alphabetical index links with data in a table? for example i have table like this:
category ------------- apple bread cornflakes doughnut egg with the above records i want to create alphabetical links like click on the letter to check its listing [A] - [B] - [C] - [D] - [E] so if someone clicks on [B] the link should take them to bread section. Many thanks awlad _______________________________________________________________________ Sheridan Phoenix Company The Business Centre Kimpton Road Luton Bedfordshire LU2 0LB Email: [EMAIL PROTECTED] Phone: 01582 522 330 Fax: 01582 522 328 _______________________________________________________________________ This electronic transmission is strictly confidential and intended solely for the addressee. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error it would be helpful if you could notify The Sheridan Phoenix Company Ltd as soon as possible. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of The Sheridan Phoenix Company Ltd. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
