$root=$DOCUMENT_ROOT;
require ("$root"."/templates/main.inc");
$category_id=13;
$subcategory_id=51;
$subcat=2;
$add_query='';
$heading='';
if ($list==1) {$heading=$subcategory='Телефоны'; $add_query='appliance_reviews.itype=2';}
elseif ($list==2) {$heading=$subcategory='Видеофоны'; $add_query='appliance_reviews.itype=3';}
elseif ($list==3) {$heading=$subcategory='Видеокамеры'; $add_query='appliance_reviews.itype=4';}
else {$heading=$subcategory='Видеосерверы'; $add_query='appliance_reviews.itype=5';}
if ($add_query) {
$add_query.=' AND ';
}
if ((isset($search)) && (isset($type)) && (isset($lan)) && (isset($wlan))) {
$type = intval($type);
$lan = intval($lan);
$wlan = intval($wlan);
$heading.=$subcategory=' (подбор по параметрам)';
if ($type) {
$add_query='appliance_reviews.itype='.$type.' AND ';
}
if ($lan) {
$add_query='appliance_reviews.lan='.$lan.' AND ';
}
if ($wlan) {
$add_query='appliance_reviews.wlan='.$wlan.' AND ';
}
}
$title=$heading;
bd_connect();
get_category_info($category_id,$subcategory_id);
print_header($category,$subcategory,$heading,$headspecial,$bodyspecial);
print_official_table(0);
print_menu_table(1);
print_subcategory_table($category_link,$category,$subcategory_link,$subcategory,$heading);
echo '
'.$heading.'
';
print_main_table_start();
start_show();
?>
Модель
Категория
Порты LAN
WLAN
Примечание
число
тип
$i=0;
$directory='net/appliance';
$query="
SELECT
appliance_reviews.id,
appliance_reviews.manufacturer,
appliance_reviews.filename,
appliance_reviews.heading,
appliance_reviews.review,
appliance_reviews.active,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
appliance_reviews.data,
appliance_reviews.comments,
appliance_reviews.itype,
appliance_reviews.lan,
appliance_reviews.wlan,
appliance_reviews.lan_count,
appliance_type.id,
appliance_type.name,
appliance_lan.id,
appliance_lan.name,
appliance_wlan.id,
appliance_wlan.name
FROM appliance_reviews
LEFT JOIN manufacturers ON manufacturers.id=appliance_reviews.manufacturer
LEFT JOIN appliance_type ON appliance_type.id=appliance_reviews.itype
LEFT JOIN appliance_lan ON appliance_lan.id=appliance_reviews.lan
LEFT JOIN appliance_wlan ON appliance_wlan.id=appliance_reviews.wlan
WHERE appliance_reviews.active=1 AND ";
$query.=$add_query ." manufacturers.kind='$cat'
ORDER BY manufacturers.name,appliance_reviews.heading";
$result=mysql_query($query,$db);
while ($row_array = mysql_fetch_array ($result)) {
if ($i==0) {$bgcolor='white'; $i++;} else {$bgcolor='#e7e7e7'; $i--;}
echo "