require_once("conn.php");
require_once("includes.php");
$q1 = "select * from class_categories order by CategoryName";
$r1 = mysql_query($q1) or die(mysql_error());
while($a1 = mysql_fetch_array($r1))
{
$MyID[] = $a1[CategoryID];
$MyName[] = $a1[CategoryName];
$q2 = "select count(*) from class_catalog where CategoryID = '$a1[CategoryID]' ";
$r2 = mysql_query($q2) or die(mysql_error());
$a2 = mysql_fetch_array($r2);
$MyNumber[] = $a2[0];
}
if(!empty($MyID))
{
for($i = '0'; $i <= (count($MyID)); $i+=2)
{
$one = $i;
$two = $i + 1;
$categories .= "\n\t\t";
if(!empty($MyID[$one]))
{
$categories .= "$MyName[$one] ($MyNumber[$one]) | \n\t\t";
}
else
{
$categories .= " | \n\t\t";
}
if(!empty($MyID[$two]))
{
$categories .= "$MyName[$two] ($MyNumber[$two]) | \n\t\t";
}
else
{
$categories .= " | \n\t\t";
}
}
}
//get the featured listings
$q1 = "select * from class_catalog, class_categories where class_catalog.CategoryID = class_categories.CategoryID and class_catalog.FeaturedStatus = '1' order by rand() limit 0,2 ";
$r1 = mysql_query($q1) or die(mysql_error());
if(mysql_num_rows($r1) > '0')
{
$FeaturedAds .= "\n\tFeatured Ads | \n
\n\n\n\t";
while($a1 = mysql_fetch_array($r1))
{
$al++;
if($al == '1')
{
$align = "align=left";
}
elseif($al == '2')
{
$align = "align=center";
}
else
{
$align = "align=right";
}
$FeaturedAds .= "\n\n\t\t";
$FeaturedAds .= "\n\t\t\n\t\t";
if(!empty($a1[images]))
{
$ShowImage = explode("|", $a1[images]);
$FeaturedAds .= " | \n\n\t\t$a1[ProductName] | \n\t\t \n\t\t";
}
else
{
$FeaturedAds .= "$a1[ProductName] | \n\t\t\n\t\t";
}
$FeaturedAds .= " \n\n\t";
$FeaturedAds .= " | \n\n\t";
$fa++;
}
for($fe = '1'; $fe <= (2 - $fa); $fe++)
{
$FeaturedAds .= " | \n\t";
}
$FeaturedAds .= "
\n\n";
$FeaturedAds .= "\n\t | \n
\n
\n\n";
}
//$banners .= "\n\n\t";
//get the templates
require_once("templates/HeaderIndex.php");
require_once("templates/IndexTemplate.php");
require_once("templates/FooterTemplate.php");
?>