This topic is locked
[SOLVED]

 sorting Category & Year/Month by desc

12/25/2012 12:17:21 PM
PHPRunner General questions
L
lkh11lkh author

//global $conn;

global $dal;
//----------------------------------------------

//Search By Category
$dal_table=$dal->Table("evevents");

$message="";

$str="SELECT Category, Count(Category) AS Count FROM ".$dal_table->TableName()." GROUP BY Category;";

$rs = CustomQuery($str);

$message.="<Font face=Tahoma size=2><b>Search By Event Category</b></Font>
";

while($data=db_fetch_array($rs))

{

$CategoryName = str_Replace(" ","+",$data["Category"]);

$message.="&nbsp;&nbsp;&nbsp;<a href=evevents_list.php?ctlSearchFor=" . $CategoryName . "&srchOptShowStatus=0&ctrlTypeComboStatus=0&srchWinShowStatus=0&a=integrated&id=1&criteria=and&value11=" . $CategoryName . "&field1=Category&option1=Contains>";

$message.= $data["Category"] . " (" . $data["Count"] . ")</a>
";

}
//------------------------------------------------------------

//Search By Month/Year
$str="SELECT date_format(FromDate,'%M %X') as Month, Count(FromDate) AS Count, Year(FromDate) AS Sort, concat(Month(FromDate),\" \",Year(FromDate)) AS monthname FROM ".$dal_table->TableName()." GROUP BY date_format(FromDate,'%M %X'), Year(FromDate), concat(Month(FromDate),\" \",Year(FromDate)) ORDER BY Year(FromDate), concat(Month(FromDate),\" \",Year(FromDate))";
$message.= "
<Font face=Tahoma size=2><b>Search By Month</b></Font>
";

$rs = CustomQuery($str);

while($data=db_fetch_array($rs))

{

$MonthName2 = str_replace(" ","+",$data["monthname"]);

$message.= "&nbsp;&nbsp;&nbsp;<a href=evevents_list.php?ctlSearchFor=" . $MonthName2 . "&srchOptShowStatus=0&ctrlTypeComboStatus=0&srchWinShowStatus=0&a=integrated&id=1&criteria=and&value11=" . $MonthName2 . "&field1=monthname&option1=Contains>";

$message.= $data["Month"] . " (" . $data["Count"] . ")</a>
";

}
$xt->assign("ListLoad",$message);
//-----------------------------------------------------------------------------------
dear sir/madam
i would like to sort the Category n Year/Month by DESC.

could u help?
please advise with thanks
merry xmas to everyone