ORDER BY question

[karimali831]

Hi

 

I can't get the ORDER BY to work correctly:

 

$getchallenges = safe_query("SELECT * FROM ".PREFIX."cup_challenges WHERE ladID='$laddID' AND challenger='$teamID' ORDER BY $order_date DESC");
   while($gc=mysql_fetch_array($getchallenges)) {

...
   if($gc['finalized_date'])
      $order_date = "finalized_date";
   elseif($gc['reply_date'])
      $order_date = "reply_date";
   else
      $order_date = "new_date";
...
}

 

Is it because of loop?

 

echo "order = $order_date";

output:

 

order =

order =

order = new_date

 

What I'm trying to achieve is to order by the latest date, but I have 3 date columns:

 

new_date

reply_date

finalized_date

 

Is it possible to order by multiple columns where largest to smallest?

[karimali831]

Will this work?

 

new_date is always shown, and reply_date/finalize_date thereafter.

 

$getchallenges = safe_query("SELECT * FROM ".PREFIX."cup_challenges WHERE ladID='$laddID' AND challenger='$teamID' ORDER BY finalized_date DESC, reply_date DESC, new_date DESC");