arranging data by date

[h4r00n]

Hi guys,

 

I have a php script to arrange my data my title, location and date. However, when the data is arranged by date it is arranged with the earliest date first, I want it to arrange it as the latest date first, how do I do this?

 

Regards

 

//

//orderBy
if(isset($_GET['orderBy'])){
switch ($_GET['orderBy']){
	case "date":
		$orderBy = " ORDER BY `Date Added` ASC";
		break;
	case "title":
		$orderBy = " ORDER BY `Title` ASC";
		break;
	case "location":
		$orderBy = " ORDER BY `Location` ASC";
		break;
	default:
		break;
}
}

[MadTechie]

change

$orderBy = " ORDER BY `Date Added` ASC";

to

$orderBy = " ORDER BY `Date Added` DESC";