$root=$DOCUMENT_ROOT;
require ("$root"."/templates/main.inc");
$category_id=13;
$subcategory_id=46;
$subcat=2;
$add_query='';
$heading='Мосты, преобразователи среды и трансиверы';
if ($list==1) {}
if ($list==2) {$heading=$subcategory='Преобразователи среды (mediaconverters)'; $add_query='mediaconv_reviews.type=2';}
elseif ($list==3) {$heading=$subcategory='Мосты (bridges)'; $add_query='mediaconv_reviews.type=3';}
elseif ($list==4) {$heading=$subcategory='Приёмопередатчики (transcievers)'; $add_query='mediaconv_reviews.type=4';}
if ($add_query) {
$add_query.=' AND ';
}
if ((isset($search)) && (isset($port_type)) && (isset($port1)) && (isset($port2))) {
$port_type = intval($port_type);
$port1 = intval($port1);
$port2 = intval($port2);
$subcategory=' (подбор по параметрам)';
if ($port_type) {
$add_query='mediaconv_reviews.type='.$port_type.' AND ';
}
if ($port1) {
$add_query.='mediaconv_reviews.port1='.$port1.' AND ';
}
if ($port2) {
$add_query.='mediaconv_reviews.port2='.$port2.' AND ';
}
}
$title=$heading.'. 3Com,D-Link и др.';
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();
?>
 |
Модель |
Категория |
Первый порт |
Второй порт |
Управление |
Примечание |
тип |
дальность |
тип |
дальность |
$i=0;
$directory='net/mediaconv';
$query="
SELECT
mediaconv_reviews.id,
mediaconv_reviews.manufacturer,
mediaconv_reviews.filename,
mediaconv_reviews.heading,
mediaconv_reviews.review,
mediaconv_reviews.active,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
mediaconv_reviews.data,
mediaconv_reviews.comments,
mediaconv_reviews.type,
mediaconv_reviews.port1,
mediaconv_reviews.port2,
mediaconv_reviews.port1_count,
mediaconv_reviews.port2_count,
mediaconv_type.id,
mediaconv_type.name,
mediaconv_port1.id,
mediaconv_port1.name,
mediaconv_port2.id,
mediaconv_port2.name,
mediaconv_reviews.managing
FROM mediaconv_reviews
LEFT JOIN manufacturers ON manufacturers.id=mediaconv_reviews.manufacturer
LEFT JOIN mediaconv_type ON mediaconv_type.id=mediaconv_reviews.type
LEFT JOIN mediaconv_port1 ON mediaconv_port1.id=mediaconv_reviews.port1
LEFT JOIN mediaconv_port2 ON mediaconv_port2.id=mediaconv_reviews.port2
WHERE mediaconv_reviews.active=1 AND ";
$query.=$add_query ." manufacturers.kind='$cat'
ORDER BY manufacturers.name,mediaconv_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 "
| $row_array[7] $row_array[3] |
$row_array[18] | $row_array[20] | $row_array[15] | $row_array[22] | $row_array[16] |
$row_array[23] | $row_array[11] |
\n";
}
stop_show();
if (!mysql_num_rows($result)) {
echo 'К сожалению, по Вашему запросу не найдено ни одной записи.
';
}
print_main_table_end();
print_copyright_table();
print_footer_table();
?>