Hi, Saturday, January 3, 2004, 1:12:49 AM, you wrote: DC> Hi List,
DC> How can I sort a while loop or do something before it to achieve the DC> following? DC> I have a MySql result fetching something like this: DC> Id Name Number DC> 1 Bob 34567 DC> 2 Ben 234 DC> 3 Jeff 4567 DC> 4 Dave 2345 DC> But I want to sort the while loop by Number Highest first so the result DC> looks like this: DC> Id Name Number DC> 1 Bob 34567 DC> 2 Jeff 4567 DC> 3 Dave 2345 DC> 4 Ben 234 DC> I have looked at sort() asort() and others in the manual and either I am DC> doing something wrong (which is more than likely) or a while loop is not DC> what I need to use to achieve this. DC> Thank you in advance for any help DC> Dave C DC> P.S: Happy New Year to you all. DC> --- DC> Outgoing mail is certified Virus Free. DC> Checked by AVG anti-virus system (http://www.grisoft.com). DC> Version: 6.0.556 / Virus Database: 348 - Release Date: 26/12/2003 add ORDER BY number DESC to your mysql query -- regards, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
