Re: [PHP] MySQL and GROUP BY

"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

> 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

[PHP] MySQL and GROUP BY

Hi All, I suspect this really can by done in my SQL query rather than afterwards in PHP but I haven't been able to find a way. I have a table with three fields: 1. First_Name 2. Last_Name 3. Business_Name A row that has a first and last name will not have a business name. A row with a busin