sorting an array within a while loop

[ryclem]

Does anyone have any ideas how to sort an array within a while loop...for instance:

while ($row = mysql_fetch_array($result))
{
if (($row['date']==$cal_date)) // && ($row['description']!= "") )
{
print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\" height=\"100\">$d<br>$row[description]</td>"; break;
}
else
{
print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\" height=\"100\">$d<br>no info<br>$cal_date<br> ".$row["date"]."</td>";
}
}

Where would I add arsort($row[description])?

Comment: What I am trying to accomplish really is to sort the array by date and then by description...for instance if a date contains four rows, it would display the one with a description first (there will only be one with a description per date)...

[Anon]

have you looked at adding on ORDER BY to you database query?

[ryclem]

I tried that and it didn't seem to work...is this the right syntax?

global $class_id;
$query = "SELECT * FROM $TableName2 where class_id = '$class_id' ORDER by description";
$result = mysql_query($query, $Link);
$numrows = mysql_num_rows($result);

[tomhath]

Think about what you are trying to accomplish:

"What I am trying to accomplish really is to sort the array by date and then by description..."

Now look at your query:

"...ORDER by description"

What's wrong with this picture?

How about?

ORDER by date, description

[ryclem]

That doesn't work for what I'm trying to accomplish....Thanks for the suggestion though...