$i=0;
$directory='multifunctional/laser_black';
$query="
SELECT
mult_lb_reviews.id,
mult_lb_reviews.manufacturer,
mult_lb_reviews.filename,
mult_lb_reviews.heading,
mult_lb_reviews.review,
mult_lb_reviews.active,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
mult_lb_reviews.size,
mult_lb_reviews.speed_print,
mult_lb_reviews.speed_scan,
mult_lb_reviews.resolution_print,
mult_lb_reviews.resolution_scan,
mult_lb_reviews.type,
mult_lb_reviews.fax,
mult_lb_reviews.network,
mult_lb_reviews.resource,
mult_lb_reviews.month_resource,
mult_lb_reviews.weight,
mult_lb_reviews.announcement,
mult_lb_reviews.announcement_year,
mult_lb_reviews.price,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
mult_lb_size.id,
mult_lb_size.name,
mult_lb_resolution_print.id,
mult_lb_resolution_print.name,
mult_lb_resolution_scan.id,
mult_lb_resolution_scan.name,
mult_lb_type.id,
mult_lb_type.name,
mult_lb_fax.id,
mult_lb_fax.name,
mult_lb_network.id,
mult_lb_network.name,
mult_lb_reviews.opinion_mark
FROM mult_lb_reviews
LEFT JOIN manufacturers ON manufacturers.id=mult_lb_reviews.manufacturer
LEFT JOIN mult_lb_size ON mult_lb_size.id=mult_lb_reviews.size
LEFT JOIN mult_lb_resolution_print ON mult_lb_resolution_print.id=mult_lb_reviews.resolution_print
LEFT JOIN mult_lb_resolution_scan ON mult_lb_resolution_scan.id=mult_lb_reviews.resolution_scan
LEFT JOIN mult_lb_type ON mult_lb_type.id=mult_lb_reviews.type
LEFT JOIN mult_lb_fax ON mult_lb_fax.id=mult_lb_reviews.fax
LEFT JOIN mult_lb_network ON mult_lb_network.id=mult_lb_reviews.network
WHERE mult_lb_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 "