Display Records From Database
View Single Post
08-15-2009, 01:53 PM
Join Date: Jul 2009
Well you could run this query 26 times - but I wont recommend it.
You have a few options:
- (MYSQL) You could use a stored procedure
- (MYSQL) Use CASE & CONCAT in mysql
- (PHP) Loop each result and substr the 1st letter and append an array accordingly
The php option is probably the simplest to implement but maybe not the most efficient.
OpenSource is the road ahead...!
View Public Profile
Send a private message to JaoudeStudios
Visit JaoudeStudios's homepage!
Find More Posts by JaoudeStudios