$i=0;
$directory='projector';
$query="
SELECT
projector_reviews.id,
projector_reviews.manufacturer,
projector_reviews.filename,
projector_reviews.heading,
projector_reviews.review,
projector_reviews.active,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
projector_reviews.type,
projector_reviews.technology,
projector_reviews.stream,
projector_reviews.weight,
projector_reviews.announcement,
projector_reviews.price,
projector_type.id,
projector_type.name,
projector_technology.id,
projector_technology.name
FROM projector_reviews
LEFT JOIN manufacturers ON manufacturers.id=projector_reviews.manufacturer
LEFT JOIN projector_type ON projector_type.id=projector_reviews.type
LEFT JOIN projector_technology ON projector_technology.id=projector_reviews.technology
WHERE projector_reviews.active=1 AND projector_reviews.type='$list' 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 "