$i=0;
$directory='security/monitor';
$query="
SELECT
secmonitor_reviews.id,
secmonitor_reviews.manufacturer,
secmonitor_reviews.filename,
secmonitor_reviews.heading,
secmonitor_reviews.review,
secmonitor_reviews.active,
secmonitor_reviews.cert_gtk,
secmonitor_reviews.cert_fapsi,
secmonitor_reviews.cert_mo,
secmonitor_reviews.cert_other,
secmonitor_reviews.desctype,
security_gtk.id,
security_gtk.name,
security_fapsi.id,
security_fapsi.name,
security_mo.id,
security_mo.name,
security_other.id,
security_other.name,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
secmonitor_reviews.class,
security_class.id,
security_class.name
FROM secmonitor_reviews
LEFT JOIN manufacturers ON manufacturers.id=secmonitor_reviews.manufacturer
LEFT JOIN security_gtk ON security_gtk.id=secmonitor_reviews.cert_gtk
LEFT JOIN security_fapsi ON security_fapsi.id=secmonitor_reviews.cert_fapsi
LEFT JOIN security_mo ON security_mo.id=secmonitor_reviews.cert_mo
LEFT JOIN security_other ON security_other.id=secmonitor_reviews.cert_other
LEFT JOIN security_class ON security_class.id=secmonitor_reviews.class
WHERE secmonitor_reviews.active=1 AND manufacturers.kind='$cat'
ORDER BY manufacturers.name, secmonitor_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 "