';
$query = 'select distinct f.firm_id as firm_id, f.fname as fname
from firms_kat k, firms f
where f.firm_id = k.firm_id and f.stat = \'1\'
AND f.city = \''.$city.'\' AND k.categories_id=\'4384\'
order by f.tarif DESC, f.fname ';
$res = $at->query($query);
while($row = $at->fetch_array($res))
{
$str .= '- '.stripslashes($row['fname']).'
';
}
$at->elem['RESTOURANT'] = $str.' |