Jeffrey Pearson wrote:
OK. I know I did this a LONG time ago but I don't remember how I did
it. Thus, my post.
I have a list of last names from a MySQL database. I need to display
them grouped by the first letter of their last names and insert a
separator on display. Similar to a phone book. So it looks like;
A
___
Adams
Apple
Army
B
__
Banjo
Bank
Bark
C
__
Captain
Car
Is there a way without jumping through too many hoops?
Thanks for any input you can give.
Order them with your query
select * from db.table order by table.lastname ASC
--
John C. Nichel IV
Programmer/System Admin (ÜberGeek)
Dot Com Holdings of Buffalo
716.856.9675
jnichel@xxxxxxxxxxxxxxxxxxxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
