$i=0;
$directory='monitor/lcd';
$query="
SELECT
lcd_reviews.id,
lcd_reviews.manufacturer,
lcd_reviews.filename,
lcd_reviews.heading,
lcd_reviews.review,
lcd_reviews.active,
lcd_reviews.diagonal,
lcd_reviews.matrix_manufacturer,
lcd_reviews.resolution,
lcd_reviews.brightness,
lcd_reviews.horiz_angle,
lcd_reviews.vert_angle,
lcd_reviews.contrast,
lcd_diagonal.id,
lcd_diagonal.name,
lcd_matrix_manufacturer.id,
lcd_matrix_manufacturer.name,
lcd_resolution.id,
lcd_resolution.name,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
lcd_dynamics.id,
lcd_dynamics.name,
lcd_video.id,
lcd_video.name,
lcd_portrait.id,
lcd_portrait.name,
lcd_usb.id,
lcd_usb.name,
lcd_digital.id,
lcd_digital.name,
lcd_reviews.opinion_mark
FROM lcd_reviews
LEFT JOIN manufacturers ON manufacturers.id=lcd_reviews.manufacturer
LEFT JOIN lcd_diagonal ON lcd_diagonal.id=lcd_reviews.diagonal
LEFT JOIN lcd_matrix_manufacturer ON lcd_matrix_manufacturer.id=lcd_reviews.matrix_manufacturer
LEFT JOIN lcd_resolution ON lcd_resolution.id=lcd_reviews.resolution
LEFT JOIN lcd_dynamics ON lcd_dynamics.id=lcd_reviews.dynamics
LEFT JOIN lcd_video ON lcd_video.id=lcd_reviews.video
LEFT JOIN lcd_portrait ON lcd_portrait.id=lcd_reviews.portrait
LEFT JOIN lcd_usb ON lcd_usb.id=lcd_reviews.usb
LEFT JOIN lcd_digital ON lcd_digital.id=lcd_reviews.digital
WHERE lcd_reviews.active=1 AND manufacturers.kind='$cat' AND $sort_query ORDER BY manufacturers.name,lcd_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[24]=converter("$row_array[24]");
$row_array[26]=converter("$row_array[26]");
$row_array[28]=converter("$row_array[28]");
$row_array[30]=converter("$row_array[30]");
$row_array[32]=converter("$row_array[32]");
echo "