$query="
SELECT
video_reviews.id,
video_reviews.manufacturer,
video_reviews.filename,
video_reviews.heading,
video_reviews.review,
video_reviews.active,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
video_reviews.chipset,
video_reviews.bus_type,
video_reviews.memmory_type,
video_reviews.memmory,
video_reviews.resolution,
video_reviews.colors,
video_reviews.frequency,
video_reviews.additional,
video_chipset.id,
video_chipset.name,
video_bus_type.id,
video_bus_type.name,
video_memmory_type.id,
video_memmory_type.name,
video_memmory.id,
video_memmory.name,
video_resolution.id,
video_resolution.name,
video_frequency.id,
video_frequency.name
FROM video_reviews
LEFT JOIN manufacturers ON manufacturers.id=video_reviews.manufacturer
LEFT JOIN video_chipset ON video_chipset.id=video_reviews.chipset
LEFT JOIN video_bus_type ON video_bus_type.id=video_reviews.bus_type
LEFT JOIN video_memmory_type ON video_memmory_type.id=video_reviews.memmory_type
LEFT JOIN video_memmory ON video_memmory.id=video_reviews.memmory
LEFT JOIN video_resolution ON video_resolution.id=video_reviews.resolution
LEFT JOIN video_frequency ON video_frequency.id=video_reviews.frequency
WHERE video_reviews.active=1 AND manufacturers.kind='$cat'
ORDER BY manufacturers.name,video_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[15]=converter("$row_array[15]");
$row_array[29]=converter("$row_array[29]");
echo "