$i=0;
$directory='scanner';
$query="
SELECT
scanner_reviews.id,
scanner_reviews.manufacturer,
scanner_reviews.filename,
scanner_reviews.heading,
scanner_reviews.review,
scanner_reviews.active,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
scanner_reviews.size,
scanner_reviews.element,
scanner_reviews.resolution,
scanner_reviews.interpolation,
scanner_reviews.interface,
scanner_reviews.deep,
scanner_reviews.length,
scanner_reviews.width,
scanner_reviews.height,
scanner_reviews.slidemode,
scanner_reviews.automode,
scanner_size.id,
scanner_size.name,
scanner_element.id,
scanner_element.name,
scanner_resolution.id,
scanner_resolution.name,
scanner_interpolation.id,
scanner_interpolation.name,
scanner_interface.id,
scanner_interface.name,
scanner_deep.id,
scanner_deep.name,
scanner_slidemode.id,
scanner_slidemode.name,
scanner_automode.id,
scanner_automode.name,
scanner_type.id,
scanner_type.name,
scanner_reviews.opinion_mark
FROM scanner_reviews
LEFT JOIN manufacturers ON manufacturers.id=scanner_reviews.manufacturer
LEFT JOIN scanner_size ON scanner_size.id=scanner_reviews.size
LEFT JOIN scanner_element ON scanner_element.id=scanner_reviews.element
LEFT JOIN scanner_resolution ON scanner_resolution.id=scanner_reviews.resolution
LEFT JOIN scanner_interpolation ON scanner_interpolation.id=scanner_reviews.interpolation
LEFT JOIN scanner_interface ON scanner_interface.id=scanner_reviews.interface
LEFT JOIN scanner_deep ON scanner_deep.id=scanner_reviews.deep
LEFT JOIN scanner_slidemode ON scanner_slidemode.id=scanner_reviews.slidemode
LEFT JOIN scanner_automode ON scanner_automode.id=scanner_reviews.automode
LEFT JOIN scanner_type ON scanner_type.id=scanner_reviews.type
WHERE scanner_reviews.active=1 AND scanner_reviews.type='$list' AND manufacturers.kind='$cat' AND manufacturers.category=11 ORDER BY manufacturers.name,scanner_reviews.heading";
$result=mysql_query($query,$db);
while ($row_array = mysql_fetch_array ($result)) {
if ($i==0) {$bgcolor='white'; $i++;} else {$bgcolor='#e7e7e7'; $i--;}
$row_array[16]=convert_zero("$row_array[16]");
$row_array[17]=convert_zero("$row_array[17]");
$row_array[18]=convert_zero("$row_array[18]");
$row_array[34]=convert_yes("$row_array[34]");
$row_array[36]=convert_yes("$row_array[36]");
echo "