$query="
SELECT
sound_reviews.id,
sound_reviews.manufacturer,
sound_reviews.filename,
sound_reviews.heading,
sound_reviews.review,
sound_reviews.active,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
sound_reviews.ac,
sound_reviews.ca,
sound_reviews.rread,
sound_reviews.rwrite,
sound_reviews.eax,
sound_reviews.a3d,
sound_reviews.d3d,
sound_reviews.ac97,
sound_reviews.optical,
sound_eax.id,
sound_eax.name,
sound_a3d.id,
sound_a3d.name,
sound_d3d.id,
sound_d3d.name,
sound_ac97.id,
sound_ac97.name,
sound_optical.id,
sound_optical.name
FROM sound_reviews
LEFT JOIN manufacturers ON manufacturers.id=sound_reviews.manufacturer
LEFT JOIN sound_eax ON sound_eax.id=sound_reviews.eax
LEFT JOIN sound_a3d ON sound_a3d.id=sound_reviews.a3d
LEFT JOIN sound_d3d ON sound_d3d.id=sound_reviews.d3d
LEFT JOIN sound_ac97 ON sound_ac97.id=sound_reviews.ac97
LEFT JOIN sound_optical ON sound_optical.id=sound_reviews.optical
WHERE sound_reviews.active=1 AND manufacturers.kind='$cat'
ORDER BY manufacturers.name,sound_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[20]=converter("$row_array[20]");
$row_array[22]=converter("$row_array[22]");
$row_array[24]=converter("$row_array[24]");
$row_array[26]=converter("$row_array[26]");
$row_array[28]=converter("$row_array[28]");
echo "