include('menu.php'); ?>
|
print($welcomeMessage); ?>
 |
 |
|
//get the sub categories
$subCatQuery = "SELECT * FROM `VC_Category` WHERE `ParentCategoryID` = 1";
$subCatResult = mysql_query($subCatQuery);
$strSubCats = "";
while($subCatRow = mysql_fetch_array($subCatResult))
{
$strSubCats .= "". stripslashes($subCatRow['Name']) ." | ";
}
//trim the end off
$strSubCats = substr($strSubCats, 0, -3);
print($strSubCats);
?> |
|
|
|
|
$categoryCount = 0;
$query1 = "SELECT * FROM `VC_Category` WHERE `ParentCategoryID` = '1' ORDER BY RAND()";
$result1 = mysql_query($query1);
while($row1 = mysql_fetch_array($result1))
{
$categoryCount++;
$categoryID = $row1['CategoryID'];
$categoryName = stripslashes($row1['Name']);
//GET PRODUCT INFO FROM THIS CATEGORY
$query2 = "SELECT * FROM `VC_Product` WHERE `CategoryID`";
//get all the subcategories for this category
$subCategories = $vitEcom->GetSubCategories($categoryID);
foreach($subCategories as $cat)
{
$query2 .= " = '$cat' OR `CategoryID`";
}
$query2 = substr($query2, 0, -16) . ' ORDER BY RAND() LIMIT 3';
$result2 = mysql_query($query2);
$row2 = mysql_fetch_array($result2);
$firstProductID = $row2['ProductID'];
$firstProductName = stripslashes($row2['ProductName']);
$firstProductDescription = substr(stripslashes($row2['ShortDescription']), 0, 40) . '...';
//get the image
$productImage = 'img/default_sm.jpg';
$query3 = "SELECT * FROM `VC_Photo` WHERE `ProductID` = '$firstProductID' ORDER BY `IsMainPhoto` DESC";
$result3 = mysql_query($query3);
if(mysql_num_rows($result3) > 0)
{
$row3 = mysql_fetch_array($result3);
$productImage = 'photos/' . $row3['ThumbLink'];
}
?>
|
if($categoryCount % 2 == 0)
{
print(" | ");
}
//END CATEGORY CODE
}
print(" ");
?>
|
|
|
|
|