$result = dbquery(
"SELECT ta.*,tac.* FROM ".$db_prefix."film ta
INNER JOIN ".$db_prefix."film_cats tac ON ta.film_cat=tac.film_cat_id
WHERE ".groupaccess('film_cat_access')." ORDER BY RAND() LIMIT 1"
);
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['film_subject'], 23);
$itemsnippet = trimlink($data['film_snippet'], 300);
$itemsnippet = nl2br($data['film_snippet']);
echo "
![".$data[](".$data[ "\".$data[")
".trimlink($data['film_subject'],27)." $new ";
}
} else {
echo " ".$locale['004']." \n";
}