|
 |
 |
|
". stripslashes($subCatRow['Name']) ." | ";
}
//trim the end off
$strSubCats = substr($strSubCats, 0, -3);
print($strSubCats);
?> |
|
|
|
|
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'];
}
?>
|
| ");
}
//END CATEGORY CODE
}
print(" ");
?>
|
|
|
|
|
