Posted by John Nichel on 01/19/06 20:28
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;
> 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
[Reply to this message]
Copyright © 2005-2006 Powered by Custom PHP Programming