$i=0;
$category_dir='/store/';
$query="
SELECT
store_reviews.id,
store_reviews.manufacturer,
store_reviews.filename,
store_reviews.heading,
store_reviews.review,
store_reviews.active,
store_reviews.temperature,
store_reviews.buffer,
store_reviews.rpm,
store_reviews.controller,
store_reviews.ata,
store_reviews.lifelength,
store_reviews.size,
store_reviews.formfactor,
store_buffer.id,
store_buffer.name,
store_rpm.id,
store_rpm.name,
store_controller.id,
store_controller.name,
store_ata.id,
store_ata.name,
store_formfactor.id,
store_formfactor.name,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind
FROM store_reviews
LEFT JOIN manufacturers ON manufacturers.id=store_reviews.manufacturer
LEFT JOIN store_buffer ON store_buffer.id=store_reviews.buffer
LEFT JOIN store_rpm ON store_rpm.id=store_reviews.rpm
LEFT JOIN store_controller ON store_controller.id=store_reviews.controller
LEFT JOIN store_ata ON store_ata.id=store_reviews.ata
LEFT JOIN store_formfactor ON store_formfactor.id=store_reviews.formfactor
WHERE store_reviews.active=1 AND store_reviews.controller='$list' AND manufacturers.kind='$cat' ORDER BY manufacturers.name,store_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[11]=converter("$row_array[11]");
echo "