ORDER BY Query
| From: | Shaun | Date: | Fri, 05 Sep 2003 12:30:37 +0000 |
| Subject: | ORDER BY Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-30347@lists.php.net to get a copy of this message | ||
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.