$CarName = mysql_query("SELECT cms_car.car FROM autohaus INNER JOIN cms_car ON autohaus.vmodel = cms_car.id WHERE vkey = '".$UserData->Name."'");
$names = array();
while($row = mysql_fetch_array($CarName)){
$names[]= $row['car'];
}
$Smarty->assign('CARNAMES',$names);
|