Sort function!!! Question!

[jjoves]

How can I get this function to sort descending!!!

function getAdminProductJumpList($skip, $search, $order=""){
$skip = (!$skip)?"0":$skip;
$order = (!$order)?"weekName":$order;

		$Q = "select "
		   . "	ds_categories.catName, "
		   . "	ds_categories.parentID, "
		   . "	ds_releases.weekName, "
		   . "	pID, "
		   . "	pArtist, "
		   . "	pName, "
		   . "	pNum, "
		   . "	pDesc, "
		   . "	pPhoto, "
		   . "	pAudio, "
		   . "	pPhotoWidth, "
		   . "	pPhotoHeight, "
		   . "	pSize, "
		   . "	pPrice, "
		   . "	pSalesPrice, "
		   . "	pSale, "
		   . "	pCurrentLevel, "
		   . "	pNotifyLevel, "
		   . "	pAvail "
		   . "from "
		   . "	ds_products, "
		   . "	ds_categories, "
		   . "	ds_releases "
		   . "where "
		   . "	ds_products.catID = ds_categories.catID and "
		   . "	ds_products.weekID = ds_releases.weekID "
		   . "";

[ir4z0r]

if I got you right, just append a
ORDER BY columnname
to your query

[jjoves]

I fgiure it out on my own -- thanks anyway --

I added "desc"

function getAdminProductJumpList($skip, $search, $order=""){ 
$skip = (!$skip)?"0":$skip; 
$order = (!$order)?"weekName desc":$order;