L
|
lkh11lkh author 2/10/2013 |
hi the above is from php runner classified template i want it to be green but it did not turn out in green. where did i miss out? please advise w thanks
|
![]() |
Sergey Kornilov admin 2/11/2013 |
Hard to tell what might be wrong without seeing your application. |
L
|
lkh11lkh author 2/12/2013 |
hi Sergey global $dal; $message="<b>Search by category</b> "; //categories $dal_table=$dal->Table("clmain"); $str = "select count(ID) as numbers, Category from ".$dal_table->TableName()." group by Category"; $rs = CustomQuery($str); while ($data = db_fetch_array($rs)) { $category = str_replace(" ","+",$data["Category"]); $message.="<a href=\"clmain_list.php?ctlSearchFor=".$category."&srchOptShowStatus=0&ctrlTypeComboStatus=0&srchWinShowStatus=0&a=integrated&id=1&criteria=and&value11=".$category."&field1=Category&option1=Contains\">".$data["Category"]." (".$data["numbers"].")</a> "; //subcategories $str2 = "select count(ID) as numbers2, Subcategory from ".$dal_table->TableName()." where Category='".$data["Category"]."' group by Subcategory"; $rs2 = CustomQuery($str2); while ($data2 = db_fetch_array($rs2)) { $subcategory = str_replace(" ","+",$data2["Subcategory"]); $message.=" <a href=\"clmain_list.php?ctlSearchFor=".$subcategory."&srchOptShowStatus=0&ctrlTypeComboStatus=0&srchWinShowStatus=0&a=integrated&id=1&criteria=and&value11=".$subcategory."&field1=Subcategory&option1=Contains\">".$data2["Subcategory"]." (".$data2["numbers2"].")</a> "; } } if ($_SESSION["UserID"]!="Guest") $message.=" <div align=center><a href=\"clown_records_list.php\" target=_blank>Edit your own records only</a></div>"; $xt->assign("ListOnLoad",$message);
|