sorting during a loop

[colinoo8]

Hi there

This loop gets one record at a time, then prints it.

Is there a way to sort the below loop, so the var $number are in desending order ?

thanks colin

while ($array = mysql_fetch_row($result2)) {
$sql1 = mysql_query("SELECT field_value FROM default_listingsDBElements WHERE field_name = 'model' AND listing_id = $array[1]");
while ($newArray1 = mysql_fetch_array($sql1)){
$number = $newArray1['field_value'];
$listing_id = $newArray1['listing_id'];
print " | <a href=\"listingview.php?listingID=$array[1]\"> $number</a> ";
}

}

[bpat1434]

Add this to the end of your statement:

ORDER BY field_value DESC

~Brett

[bubblenut]

Just to clarify, bpat1434 is talking about the initial query, ie. the one controling the while loop.