In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> 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.
You'll need to mix a bit of php with your sql to get the desired result.
SELECT * FROM Users WHERE whatever ORDER BY Location, Name
Then when you display the results, initialise a variable to keep track of
the last value of Location. If it differs from the current value, display
the location. This way you end up with something like:
Quod subigo farinam
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
Q: What is the most annoying thing on usenet?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php