what is the 2? in the order by statement mean? thanks -----Original Message----- From: Raśl Castro [mailto:[EMAIL PROTECTED] Sent: Thursday, June 03, 2004 6:20 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Best way to sort?
The best way is: SELECT person_name, count(*) FROM table_name GROUP BY person_name ORDER BY 2 DESC ----- Original Message ----- From: "Daniel Clark" <[EMAIL PROTECTED]> To: "Brian Dunning" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, June 03, 2004 10:30 AM Subject: Re: [PHP] Best way to sort? > SELECT DISTINCT person_name, count(*) > FROM table_name > GROUP BY person_name > ORDER BY 2 DESC > > > I'm not sure if this is a complex SQL query or a PHP array sorting > > thing, but what's the best way to take this data: > > > > Tom > > Greg > > Brian > > Tom > > Brian > > Tom > > > > And return the following results, sorted by number of records: > > > > Tom - 3 > > Brian - 2 > > Greg - 1 > > > > Any thoughts? > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -------------------------------------------------------------------- Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
