PHP Code:
<?php
/**
* tv_display_size sidebox - displays list of available music genres to filter on
*
* @package templateSystem
* @copyright Copyright 2003-2005 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: tv_display_size.php 2834 2006-01-11 22:16:37Z birdbrain $
*/
$tv_display_size_query = "select tv_display_size_id, tv_display_size_name
from " . TABLE_TV_DISPLAY_SIZE . "
order by tv_display_size_name";
$tv_display_size = $db->Execute($tv_display_size_query);
if ($tv_display_size->RecordCount()>0) {
$number_of_rows = $tv_display_size->RecordCount()+1;
// Display a list
$tv_display_size_array = array();
if (!isset($_GET['tv_display_size_id']) || $_GET['tv_display_size_id'] == '' ) {
$tv_display_size_array[] = array('id' => '', 'text' => PULL_DOWN_ALL);
} else {
$tv_display_size_array[] = array('id' => '', 'text' => PULL_DOWN_TV_DISPLAY_SIZE);
}
while (!$tv_display_size->EOF) {
$tv_display_size_name = ((strlen($tv_display_size->fields['tv_display_size_name']) > MAX_DISPLAY_TV_DISPLAY_SIZE_NAME_LEN) ? substr($tv_display_size->fields['tv_display_size_name'], 0, MAX_DISPLAY_TV_DISPLAY_SIZE_NAME_LEN) . '..' : $tv_display_size->fields['tv_display_size_name']);
$tv_display_size_array[] = array('id' => $tv_display_size->fields['tv_display_size_id'],
'text' => $tv_display_size_name);
$tv_display_size->MoveNext();
}
require($template->get_template_dir('tpl_tv_display_size_select.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_tv_display_size_select.php');
$title = '<label>' . BOX_HEADING_TV_DISPLAY_SIZE . '</label>';
$title_link = false;
require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
}
?>