Re: [PHP] Best way to sort?
Brian Dunning wrote: 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? I'm not a SQL expert, but try : select field, count(field) from TableName group by field having count(*) 1 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Best way to sort?
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
RE: [PHP] Best way to sort?
Order by the 2nd column 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
Re: [PHP] Best way to sort?
yes, Is the column number on select statement. You could use alias too: SELECT person_name, count(*) count FROM table_name GROUP BY person_name ORDER BY count DESC - Original Message - From: Angelo Zanetti [EMAIL PROTECTED] To: Raúl Castro [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 04, 2004 2:20 AM Subject: RE: [PHP] Best way to sort? 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
Re: [PHP] Best way to sort?
Brian Dunning wrote: 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? MySQL's DISTINCT, in conjuction with COUNT -- John C. Nichel KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Best way to sort?
select thename, count(thename) from tablename order by thename asc group by thename Try this -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Thursday, June 03, 2004 3:41 PM To: [EMAIL PROTECTED] Subject: [PHP] Best way to sort? 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 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
Re: [PHP] Best way to sort?
Angelo Zanetti [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] select thename, count(thename) from tablename order by thename asc group by thename or... to sort by number of records select name, count(name) as ncnt from table group by name order by ncnt desc -- Rob -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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
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
RE: [PHP] Best way to sort a multidimentional array....
-Original Message- From: Mark Cubitt [mailto:[EMAIL PROTECTED]] Sent: 19 February 2003 12:43 I need to manipulate, the following data in a number of diffierent ways I'm storing the data in a multidemensional array, the stucture of which is below, and I need to sort it by Total Time On Phone in decending order, which is the first element of the 'embedded' array. //just filled with some descriptive default values $extensionsDetails = array('Total Time On Phone', 'Total Number of calls', 'name of person'); // a hash of extention numbers and the $extensionsDetails array (above) $telData = array( // management '2000' = $extensionsDetails, '2001' = $extensionsDetails, Use usort() with a callback that compares the 'Total Time On Phone' elements. Something like: function compTime($a, $b) { return $a[0]==$b[0]?0:($a[0]$b[0]?1:-1); } usort($telData, 'compTime'); Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University, Beckett Park, LEEDS, LS6 3QS, United Kingdom Email: [EMAIL PROTECTED] Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php