$i=0;
$directory='printer/inkjet';
$query="
SELECT
printer_reviews.id,
printer_reviews.manufacturer,
printer_reviews.filename,
printer_reviews.heading,
printer_reviews.review,
printer_reviews.active,
printer_reviews.size,
printer_reviews.speed_black,
printer_reviews.speed_color,
printer_reviews.resolution,
printer_reviews.colors,
printer_reviews.type,
printer_reviews.weight,
printer_reviews.cartridge,
printer_reviews.resource,
printer_size.id,
printer_size.name,
printer_resolution.id,
printer_resolution.name,
printer_type.id,
printer_type.name,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
printer_reviews.opinion_mark
FROM printer_reviews
LEFT JOIN manufacturers ON manufacturers.id=printer_reviews.manufacturer
LEFT JOIN printer_size ON printer_size.id=printer_reviews.size
LEFT JOIN printer_resolution ON printer_resolution.id=printer_reviews.resolution
LEFT JOIN printer_type ON printer_type.id=printer_reviews.type
WHERE printer_reviews.active=1 AND manufacturers.kind='$cat' ORDER BY manufacturers.name,printer_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 "