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