$root=$DOCUMENT_ROOT;
require ("$root"."/templates/main.inc");
$category_id=37;
$subcategory_id=36;
$subcat=2;
$title='МФУ струйные. МФУ Brother,Canon,Epson,HP,Lexmark,Olivetti,Samsung.';
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 '
МФУ струйные
';
print_main_table_start();
if (isset($order)) {
echo "Сортировать по производителю
";
$order='mult_inkjet_reviews.price';
}
else {
echo "Сортировать по цене
";
$order='manufacturers.name,mult_inkjet_reviews.heading';
}
start_show();
$montharray= array ('skip','Январь','Февраль','Март','Апрель','Май','Июнь','Июль','Август','Сентябрь','Октябрь','Ноябрь','Декабрь');
?>
 |
Модель |
Формат |
Скорость печати (стр./мин) |
Скорость сканирования (стр./мин) |
Макс. разр. печати (тнд) |
Макс. разр. сканирования (пнд) |
Тип сканера |
Факс |
Сеть |
Ресурс картриджа (тыс. стр.) |
Макс. мес. нагр. печати (тыс. стр.) |
Вес |
Дата анонса |
Цена |
Оценка |
ч/б |
цв. |
ч/б |
цв. |
$i=0;
$directory='multifunctional/inkjet';
$query="
SELECT
mult_inkjet_reviews.id,
mult_inkjet_reviews.manufacturer,
mult_inkjet_reviews.filename,
mult_inkjet_reviews.heading,
mult_inkjet_reviews.review,
mult_inkjet_reviews.active,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
mult_inkjet_reviews.size,
mult_inkjet_reviews.speed_print,
mult_inkjet_reviews.speed_scan,
mult_inkjet_reviews.resolution_print,
mult_inkjet_reviews.resolution_scan,
mult_inkjet_reviews.type,
mult_inkjet_reviews.fax,
mult_inkjet_reviews.network,
mult_inkjet_reviews.resource,
mult_inkjet_reviews.month_resource,
mult_inkjet_reviews.weight,
mult_inkjet_reviews.announcement,
mult_inkjet_reviews.announcement_year,
mult_inkjet_reviews.price,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
mult_inkjet_size.id,
mult_inkjet_size.name,
mult_inkjet_resolution_print.id,
mult_inkjet_resolution_print.name,
mult_inkjet_resolution_scan.id,
mult_inkjet_resolution_scan.name,
mult_inkjet_type.id,
mult_inkjet_type.name,
mult_inkjet_fax.id,
mult_inkjet_fax.name,
mult_inkjet_network.id,
mult_inkjet_network.name,
mult_inkjet_reviews.speed_print_color,
mult_inkjet_reviews.resource_color,
mult_inkjet_reviews.opinion_mark
FROM mult_inkjet_reviews
LEFT JOIN manufacturers ON manufacturers.id=mult_inkjet_reviews.manufacturer
LEFT JOIN mult_inkjet_size ON mult_inkjet_size.id=mult_inkjet_reviews.size
LEFT JOIN mult_inkjet_resolution_print ON mult_inkjet_resolution_print.id=mult_inkjet_reviews.resolution_print
LEFT JOIN mult_inkjet_resolution_scan ON mult_inkjet_resolution_scan.id=mult_inkjet_reviews.resolution_scan
LEFT JOIN mult_inkjet_type ON mult_inkjet_type.id=mult_inkjet_reviews.type
LEFT JOIN mult_inkjet_fax ON mult_inkjet_fax.id=mult_inkjet_reviews.fax
LEFT JOIN mult_inkjet_network ON mult_inkjet_network.id=mult_inkjet_reviews.network
WHERE mult_inkjet_reviews.active=1 AND manufacturers.kind='$cat' ORDER BY ".$order;
$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[29]." | ".convert_zero($row_array[11])." | ".convert_zero($row_array[40])." | ".convert_zero($row_array[12])." | ".$row_array[31]." | ".$row_array[33]." | ".$row_array[35]." | ".$row_array[37]." | ".$row_array[39]." | ".convert_zero($row_array[18])." | ".convert_zero($row_array[41])." | ".convert_zero($row_array[19])." | ".$row_array[20]." | ".$row_array[21]." | ".convert_zero($row_array[23])." | ".convert_zero("$row_array[42]")." |
\n";;
}
stop_show();
print_main_table_end();
print_copyright_table();
print_footer_table();
?>