$i=0;
$directory='monitor/crt';
$query="
SELECT
crt_reviews.id,
crt_reviews.manufacturer,
crt_reviews.filename,
crt_reviews.heading,
crt_reviews.review,
crt_reviews.active,
crt_reviews.diagonal,
crt_reviews.tube_manufacturer,
crt_reviews.resolution,
crt_reviews.vert_scanning,
crt_reviews.horiz_scanning,
crt_reviews.point_step,
crt_reviews.screen_type,
crt_diagonal.id,
crt_diagonal.name,
crt_tube_manufacturer.id,
crt_tube_manufacturer.name,
crt_resolution.id,
crt_resolution.name,
crt_screen_type.id,
crt_screen_type.name,
crt_horiz_scanning.id,
crt_horiz_scanning.name,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
crt_usb.id,
crt_usb.name,
crt_dsub.id,
crt_dsub.name,
crt_bnc.id,
crt_bnc.name,
crt_dynamics.id,
crt_dynamics.name,
crt_reviews.opinion_mark
FROM crt_reviews
LEFT JOIN manufacturers ON manufacturers.id=crt_reviews.manufacturer
LEFT JOIN crt_diagonal ON crt_diagonal.id=crt_reviews.diagonal
LEFT JOIN crt_tube_manufacturer ON crt_tube_manufacturer.id=crt_reviews.tube_manufacturer
LEFT JOIN crt_resolution ON crt_resolution.id=crt_reviews.resolution
LEFT JOIN crt_horiz_scanning ON crt_horiz_scanning.id=crt_reviews.horiz_scanning
LEFT JOIN crt_screen_type ON crt_screen_type.id=crt_reviews.screen_type
LEFT JOIN crt_usb ON crt_usb.id=crt_reviews.usb
LEFT JOIN crt_dsub ON crt_dsub.id=crt_reviews.dsub
LEFT JOIN crt_bnc ON crt_bnc.id=crt_reviews.bnc
LEFT JOIN crt_dynamics ON crt_dynamics.id=crt_reviews.dynamics
WHERE crt_reviews.active=1 AND manufacturers.kind='$cat' AND $sort_query ORDER BY manufacturers.name,crt_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[28]=converter("$row_array[28]");
$row_array[30]=converter("$row_array[30]");
$row_array[32]=converter("$row_array[32]");
$row_array[34]=converter("$row_array[34]");
echo "