.'.gif)
';
$PAGE_CONTENT = '';
// Retrieve Items
$init_items = $db->select( 'items.itemID,items.stock,SUM(carts.quantity) AS quantity',
'items,categories LEFT JOIN carts ON (items.itemID=carts.itemID)',
'categories.name="'.$c.'" AND categories.categoryID=items.categoryID AND items.status="Available" AND items.stock > 0',
'',
'GROUP BY items.itemID ORDER BY items.itemID DESC');
$items = array();
foreach ($init_items as $item)
{
if ($item['stock'] > $item['quantity'])
$items[] = $item;
}
if (count($items) > 0)
{
foreach ($items as $prod)
{
$item = new Item($prod['itemID']);
// Determine file path of thumbnail for product
$thumb_path = _IMAGE_DIR._THUMB_DIR.$item->image1;
// Check if file exists
if (file_exists($thumb_path))
$thumb = _IMAGE_URL._THUMB_DIR.$item->image1;
// If not use missing image
else
$thumb = _SITE_URL.'images/no_image.gif';
if ($unavailable == $item->id)
{
if (rq('det'))
{
$missing_fields = array();
$db_missing_fields = $db->select('field_default','schemaFields','fieldID IN ('.rq('det').')','list_order');
foreach ($db_missing_fields as $missing_field)
$missing_fields[] = $missing_field['field_default'];
$unv_msg = '| {$item->name} |