$root=$DOCUMENT_ROOT;
require ("$root"."/templates/main.inc");
$category_id=13;
$subcategory_id=45;
$subcat=2;
$add_query='';
$heading='';
if ((isset($search)) && (isset($lan_count)) && (isset($lan)) && (isset($comp))) {
$lan_count = intval($lan_count);
$lan = intval($lan);
$comp = intval($comp);
$heading.=$subcategory=' (подбор по параметрам)';
if ($lan_count) {
$add_query='modem_reviews.lan_count='.$lan_count.' AND ';
}
if ($lan) {
$add_query.='modem_reviews.lan='.$lan.' AND ';
}
if ($comp) {
$add_query.='modem_reviews.comp='.$comp.' AND ';
}
}
$title='Модемы '.$heading.'. Модемы D-Link, U.S. Robotics Sportster и др.';
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();
?>
Модель
OSI
Сетевые порты
Порт компьютера
Протоколы
Примечание
N
тип
$i=0;
$directory='net/modem';
$query="
SELECT
modem_reviews.id,
modem_reviews.manufacturer,
modem_reviews.filename,
modem_reviews.heading,
modem_reviews.review,
modem_reviews.active,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
modem_reviews.data,
modem_reviews.comments,
modem_reviews.level,
modem_reviews.lan,
modem_reviews.comp,
modem_reviews.lan_count,
modem_reviews.protocols,
modem_level.id,
modem_level.name,
modem_lan.id,
modem_lan.name,
modem_comp.id,
modem_comp.name
FROM modem_reviews
LEFT JOIN manufacturers ON manufacturers.id=modem_reviews.manufacturer
LEFT JOIN modem_level ON modem_level.id=modem_reviews.level
LEFT JOIN modem_lan ON modem_lan.id=modem_reviews.lan
LEFT JOIN modem_comp ON modem_comp.id=modem_reviews.comp
WHERE modem_reviews.active=1 AND ";
$query.=$add_query ." manufacturers.kind='$cat'
ORDER BY manufacturers.name,modem_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 "