//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.=" <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.= " <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