$i=0;
$category_dir='/motherboard/';
$query="
SELECT
motherboard_reviews.id,
motherboard_reviews.active,
motherboard_reviews.manufacturer,
motherboard_reviews.filename,
motherboard_reviews.heading,
motherboard_reviews.review,
motherboard_reviews.socket,
motherboard_reviews.processor,
motherboard_reviews.memmory,
motherboard_reviews.chipset,
motherboard_reviews.rimm,
motherboard_reviews.ddr,
motherboard_reviews.dimm,
motherboard_reviews.maxmem,
motherboard_reviews.frequency,
motherboard_reviews.agp,
motherboard_reviews.pci,
motherboard_reviews.isa,
motherboard_reviews.anotherslot,
motherboard_reviews.ata,
motherboard_agp.id,
motherboard_agp.name,
motherboard_ata.id,
motherboard_ata.name,
motherboard_chipset.id,
motherboard_chipset.name,
motherboard_frequency.id,
motherboard_frequency.name,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
motherboard_maxmem.id,
motherboard_maxmem.name,
motherboard_socket.id,
motherboard_socket.name,
manufacturers.category
FROM motherboard_reviews
LEFT JOIN motherboard_agp ON motherboard_agp.id=motherboard_reviews.agp
LEFT JOIN motherboard_ata ON motherboard_ata.id=motherboard_reviews.ata
LEFT JOIN motherboard_chipset ON motherboard_chipset.id=motherboard_reviews.chipset
LEFT JOIN motherboard_frequency ON motherboard_frequency.id=motherboard_reviews.frequency
LEFT JOIN manufacturers ON manufacturers.id=motherboard_reviews.manufacturer
LEFT JOIN motherboard_maxmem ON motherboard_maxmem.id=motherboard_reviews.maxmem
LEFT JOIN motherboard_socket ON motherboard_socket.id=motherboard_reviews.socket
WHERE motherboard_reviews.active=1 AND motherboard_reviews.socket='$list' AND manufacturers.kind='$cat' AND manufacturers.category=1 ORDER BY manufacturers.name,motherboard_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 "