??
require("../config.php");
require($doc_lib."class.query.php");
//session_start();
$scat = "";
$mcat = "";
$hcid = "";
$query = new classQuery();
// generate the archive date and url
for($x=3;$x>0;$x--)
{
$d = date("m-Y",mktime(0,0,0,date("m")-($x-1),date("d"),date("Y")));
$fd = date("F",mktime(0,0,0,date("m")-($x-1),date("d"),date("Y")));
$archive .="$fd ";
}
$sql = "SELECT cat.id,cat.name,count(p.special) as cnt FROM category as cat, product as p WHERE p.categoryid=cat.id AND p.special='1' GROUP BY cat.id HAVING cnt>0 ORDER BY cat.name";
$res = $query->query($sql);
$num = $query->numrows($res);
$i=0;
while($row=mysql_fetch_assoc($res))
{
$sql = "SELECT photo1 FROM product WHERE categoryid=$row[id] AND photo1<>'' ORDER BY RAND() LIMIT 1";
$rs = $query->query($sql);
$rw = mysql_fetch_assoc($rs);
if($i%5==0)
$speciallist .= "
