Re: [PHP] MySQL and GROUP BY

2001-11-20 Thread Steve Werby
"David Freeman" <[EMAIL PROTECTED]> wrote: > SELECT * FROM My_Table ORDER BY Business_Name, Last_Name, First_Name; > > What I would _like_ to have happen is that the select list will end up > sorted by business name as well as last name and then first name. At > the moment this query is resulting

Re: [PHP] MySQL and GROUP BY

2001-11-20 Thread Jon Farmer
> At the moment I am doing something like this for my SQL statement > (simplified for just the bit I need to figure out): > > SELECT * FROM My_Table ORDER BY Business_Name, Last_Name, First_Name; > > What I would _like_ to have happen is that the select list will end up > sorted by business name a