num_rows;
$counter = 0;
while ($catRow = $catR->fetch_assoc()) {
$id = $catRow["id"];
$catName = stripslashes($catRow["name"]);
$catDesc = $catRow["description"]; //leave as slashed for proper href title display
$catColor = "#".$catRow["daColor"];
$catLayout = NULL;
$cssLeft = intval($counter * $catWidth);
$catWidth = intval(1000 / $catCount);
$counter++;
if ($counter == $catCount)
$catWidth = $catWidth + (1000 - ($catWidth * $catCount)); //to capture any remaining extra pixels
//set the main color for the page, based on the category
if($id == $catID) {
$mainCatColor = $catColor;
$catHeader = $catRow["imgName"];
}
$catLayout .= "\t\n";
echo "\t\t\t".$catLayout;
}
$catR->free();
?>
fetch_row()) {
$cellCount++;
//SELECT categories.id AS catID, categories.name, categories.description, products.id AS prodID, products.name, products.itemNumber, products.imgType
$catID = $row[0];
$catName = stripslashes($row[1]);
$catDesc = stripslashes($row[2]);
$prodID = $row[3];
$name = stripslashes($row[4]);
$itemNumber = $row[5];
$imgType = $row[6];
$img = $itemNumber.".".$imgType;
$catLayout = NULL;
$daLink = "";
if (is_file($catPath.$img))
$prodIMG = $prodImgPath.$img;
else
$prodIMG = $prodImgPath."noImage.png";
if ($cellCount == 1)
$catLayout .= "
\n\t
";
?>
";
else {
$cssLeft = intval(($cellCount - 1) * 180);
$catLayout .= "\t
\n";
$cellCount = 0;
}
echo "\t\t\t".$catLayout;
}
$results->free();
if ($cellCount)
echo "";
}
$catLayout .= $daLink."![\"".$name."\"](\"".$prodIMG."\")
\n"; $catLayout .= $itemNumber."
\n";
if ($cellCount == 5) {
$catLayout .= "\n"; $catLayout .= $itemNumber."
\n".$name."