$i=0;
$directory='server';
$query="
SELECT
server_reviews.id,
server_reviews.manufacturer,
server_reviews.filename,
server_reviews.heading,
server_reviews.review,
server_reviews.active,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
server_reviews.level,
server_reviews.perfomance,
server_reviews.class,
server_reviews.os,
server_reviews.processors,
server_reviews.processor_type,
server_reviews.motherboard,
server_reviews.ram,
server_reviews.hdd,
server_level.id,
server_level.name,
server_perfomance.id,
server_perfomance.name,
server_os.id,
server_os.name,
server_processors.id,
server_processors.name,
server_processor_type.id,
server_processor_type.name,
server_ram.id,
server_ram.name,
server_hdd.id,
server_hdd.name
FROM server_reviews
LEFT JOIN manufacturers ON manufacturers.id=server_reviews.manufacturer
LEFT JOIN server_level ON server_level.id=server_reviews.level
LEFT JOIN server_perfomance ON server_perfomance.id=server_reviews.perfomance
LEFT JOIN server_os ON server_os.id=server_reviews.os
LEFT JOIN server_processors ON server_processors.id=server_reviews.processors
LEFT JOIN server_processor_type ON server_processor_type.id=server_reviews.processor_type
LEFT JOIN server_ram ON server_ram.id=server_reviews.ram
LEFT JOIN server_hdd ON server_hdd.id=server_reviews.hdd
WHERE server_reviews.active=1 AND server_reviews.level='$list' AND manufacturers.kind='$cat' AND manufacturers.category=30 ORDER BY manufacturers.name,server_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 "