mysql_fetch_assoc Column als Variable speisen

[sanktusm]

Hallo folgendes Problem,
ich habe ich eine dynamische Ausgabe von Text:

wenn ich $text['headline'] eingebe bekomme ich die richtige Ausgabe.
wenn ich $text[$column] eingeben, bekomme ich keine

Ich habe getestet ob unter dem Array $columns headline vorhanden ist, das ist der Fall.

Woran könnte der Fehler liegen

$sql = "SELECT 
             orders.id";
foreach($columns as $column)
$sql .= ", ".$table.".".$column;
   
$sql .= " FROM            
           ".$table.",
           orders
         WHERE
           orders.main_id = '$id' AND
           orders.relid = ".$table.".relid;";
$result = mysql_query($sql) OR die (mysql_error());
$text = mysql_fetch_assoc($result);
 
 foreach($columns as $column)
 $textofsection .= $text[$column]; 

[h3ll]

Wo sind deine Debug-Ausgaben?

[sanktusm]

Hier wenn ich nur $colums ausgebe bekomme ich folgendes

id logo logo_name logo_link background background_name background_link language language_link countyicon countyicon_name countyicon_link city city_link public_status language_id site_id relid orders country_icon country_icon_name country_icon_link city_description city_description_link id image image_name image_link plain_text plain_text_link icon icon_name icon_link public_status language_id site_id relid orders headline headline_link id slider_title slider_title_link switched_image switched_image_name switched_image_link headline headline_link text text_link public_status language_id site_id relid orders google_icon google_icon_name google_icon_link keyword_s__1 keyword_s__1_link keyword_s__2 keyword_s__2_link keyword_s__3 keyword_s__3_link keyword_s__4 keyword_s__4_link keyword_s__5 keyword_s__5_link id headline headline_link text text_link shortlink shortlink_link news news_link public_status language_id site_id relid orders headline_right headline_right_link tabdescription tabdescription_link shortlink_text shortlink_text_link id email_formsemail_forms_link public_status language_id site_id relid orders email_form email_form_link headline headline_link instructions instructions_link id headline headline_link text text_link public_status language_id site_id relid orders id short_text short_text_link public_status language_id site_id relid orders small_headline small_headline_link id image_right image_right_name image_right_link public_status language_id site_id relid orders id action_url action_url_link feldname__email_ feldname__email__link feldname__passwort_ feldname__passwort__link public_status language_id site_id relid orders

[sanktusm]

ok ich hab den Fehler

gefunden,
$column hatte leerzeichen

[TobiaZ]

Wahnsinn!!!!