$i=0;
$directory='printer/laser_color';
$query="
SELECT
laser_color_reviews.id,
laser_color_reviews.manufacturer,
laser_color_reviews.filename,
laser_color_reviews.heading,
laser_color_reviews.review,
laser_color_reviews.active,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
laser_color_reviews.freq,
laser_color_reviews.technology,
laser_color_reviews.dpi,
laser_color_reviews.speed_black,
laser_color_reviews.speed_color,
laser_color_reviews.memory_def,
laser_color_reviews.memory_max,
laser_color_reviews.density,
laser_color_reviews.range,
laser_color_reviews.resource,
laser_color_reviews.duplex,
laser_color_reviews.gdi,
laser_color_reviews.weight,
laser_color_reviews.size,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
laser_color_freq.id,
laser_color_freq.name,
laser_color_technology.id,
laser_color_technology.name,
laser_color_dpi.id,
laser_color_dpi.name,
laser_color_memory_def.id,
laser_color_memory_def.name,
laser_color_memory_max.id,
laser_color_memory_max.name,
laser_color_density.id,
laser_color_density.name,
laser_color_duplex.id,
laser_color_duplex.name,
laser_color_gdi.id,
laser_color_gdi.name,
laser_color_size.id,
laser_color_size.name,
laser_color_reviews.opinion_mark
FROM laser_color_reviews
LEFT JOIN manufacturers ON manufacturers.id=laser_color_reviews.manufacturer
LEFT JOIN laser_color_freq ON laser_color_freq.id=laser_color_reviews.freq
LEFT JOIN laser_color_technology ON laser_color_technology.id=laser_color_reviews.technology
LEFT JOIN laser_color_dpi ON laser_color_dpi.id=laser_color_reviews.dpi
LEFT JOIN laser_color_memory_def ON laser_color_memory_def.id=laser_color_reviews.memory_def
LEFT JOIN laser_color_memory_max ON laser_color_memory_max.id=laser_color_reviews.memory_max
LEFT JOIN laser_color_density ON laser_color_density.id=laser_color_reviews.density
LEFT JOIN laser_color_duplex ON laser_color_duplex.id=laser_color_reviews.duplex
LEFT JOIN laser_color_gdi ON laser_color_gdi.id=laser_color_reviews.gdi
LEFT JOIN laser_color_size ON laser_color_size.id=laser_color_reviews.size
WHERE laser_color_reviews.active=1 AND manufacturers.kind='$cat' ORDER BY manufacturers.name,laser_color_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 "