$root=$DOCUMENT_ROOT;
require ("$root"."/templates/main.inc");
$category_id=16;
$subcategory_id=14;
$subcat=2;
bd_connect();
get_category_info($category_id,$subcategory_id);
$title='Лазерные принтеры. Принтеры Brother,Canon,Epson,HP,Konica-Minolta,Xerox ,Lexmark,OKI,Samsung.';
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 '
Лазерные принтеры
';
print_main_table_start();
start_show();
?>
 |
Модель |
Формат |
Макс. cкорость печати |
Макс. разрешиние |
Память |
Объём лотков |
Вес кг. |
Ресурс карт. |
Ресурс |
Оценка |
уст. |
макс. |
вх.+доп. |
вых.+доп. |
$i=0;
$directory='printer/laser';
$query="
SELECT
laser_reviews.id,
laser_reviews.manufacturer,
laser_reviews.filename,
laser_reviews.heading,
laser_reviews.review,
laser_reviews.active,
laser_reviews.size,
laser_reviews.speed,
laser_reviews.resolution,
laser_reviews.memmory_def,
laser_reviews.memmory_max,
laser_reviews.tray_in_def,
laser_reviews.tray_in_max,
laser_reviews.tray_out_def,
laser_reviews.tray_out_max,
laser_reviews.weight,
laser_reviews.cartridge,
laser_reviews.resource,
laser_size.id,
laser_size.name,
laser_resolution.id,
laser_resolution.name,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
laser_reviews.opinion_mark
FROM laser_reviews
LEFT JOIN manufacturers ON manufacturers.id=laser_reviews.manufacturer
LEFT JOIN laser_size ON laser_size.id=laser_reviews.size
LEFT JOIN laser_resolution ON laser_resolution.id=laser_reviews.resolution
WHERE laser_reviews.active=1 AND manufacturers.kind='$cat' ORDER BY manufacturers.name,laser_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[23] $row_array[3] | $row_array[19] | ".convert_zero("$row_array[7]")." | $row_array[21] | ".convert_zero("$row_array[9]")." | ".convert_zero("$row_array[10]")." | ".convert_zero("$row_array[11]")."+".convert_zero("$row_array[12]")." | ".convert_zero("$row_array[13]")."+".convert_zero("$row_array[14]")." | ".convert_zero("$row_array[15]")." | ".convert_zero("$row_array[16]")." | ".convert_zero("$row_array[17]")." | ".convert_zero("$row_array[26]")." |
\n";
}
stop_show();
print_main_table_end();
print_copyright_table();
print_footer_table();
?>