subject:"\[PHP\-DB\] ORDER BY Query"

Re: [PHP-DB] ORDER BY Query

2003-09-05 Thread John W. Holmes

Shaun wrote: I have a table in my database called Users. This table has (among others) two columns called Location and Name. Location will be either 1, 2, 3, or 4. How can I produce a query that groups the result into Location and then for each Location order the User by Name? Learn SQL, please.

[PHP-DB] ORDER BY Query

2003-09-05 Thread Shaun

Hi, I have a table in my database called Users. This table has (among others) two columns called Location and Name. Location will be either 1, 2, 3, or 4. How can I produce a query that groups the result into Location and then for each Location order the User by Name? Thanks for your help. -- P