db->query("select * from categories where active='1' order by sort ASC");
$body_width = 760; // this is the width - if the next item is going past that, wrap
foreach($categories as $cat) {
echo "
".General::fixtext($cat["name"],"tinymce_inline")."
";
$products = $page->db->query("select * from products where active='1' and category_uid = '".$cat["uid"]."' order by sort ASC");
$current_x_position = 0;
foreach($products as $prod) {
$link = "prods/".General::urlify($cat["name"])."/".General::urlify($prod["name"])."/".$prod["uid"]."/";
// look for thumbnail
if (file_exists(SITE_PATH."images_thumb/".$prod["uid"].".jpg")) {
$thumb = SITE_URL."images_thumb/".$prod["uid"].".jpg";
list($width, $height) = getimagesize(SITE_PATH."images_thumb/".$prod["uid"].".jpg");
} else {
$thumb = SITE_URL."images_thumb/thumb_missing.jpg";
$height = 80;
$width = 80;
}
$thumb_image = "![\"".str_replace("\"","",General::fixtext($prod["name"],"tinymce"))."\"](".$thumb.")
";
$current_x_position += (10 + $width);
if ($current_x_position > $body_width) {
echo "
";
$current_x_position = (10 + $width);
}
// below min was 150px (in the max() function)
echo " |
| \n";
}
// finish up the table - the TR is always open
echo "
".General::fixtext($cat["description"],"tinymce")."
";
}
?>
