Problem mit SELECT-Anweisung für mySQL

Einklappen
X
 
  • Filter
  • Zeit
  • Anzeigen
Alles löschen
neue Beiträge

  • #16
    Das [COLOR=red]printf()[/COLOR] hatte ich in meinem Code bei mir. Ich hatte das [COLOR=red]echo "";[/COLOR] , nachdem ich meinen Code in das Forum gepostet hatte, gegen [COLOR=red]printf()[/COLOR] getauscht:
    Code:
    [COLOR=green]if (=![/COLR][COLOR=blue]mysql_error[/COLOR][COLOR=green]()) {[/COLOR]
           [COLOR=green]while([/COLOR][COLOR=blue]$row[/COLOR] [COLOR=green]=[/COLOR][COLOR=blue]mysql_fetch_array[/COLOR] [COLOR=green]([/COLOR][COLOR=blue]$exec[/COLOR] [COLOR=green],[/COLOR] [COLOR=blue]MYSQL_ASSOC[/COLOR] [COLOR=green])) {[/COLOR]
             [COLOR=blue]$sel_ID[/COLOR]          [COLOR=green]=[/COLOR][COLOR=blue]$row[/COLOR][COLOR=green][[/COLOR][COLOR=red]'pro_id_fld'[/COLOR][COLOR=green]] ;[/COLOR]
             [COLOR=blue]$sel_produkt[/COLOR]     [COLOR=green]=[/COLOR][COLOR=blue]$row[/COLOR][COLOR=green][[/COLOR][COLOR=red]'pro_produkt_fld'[/COLOR][COLOR=green]];[/COLOR]
             [COLOR=blue]$sel_prodart[/COLOR]     [COLOR=green]=[/COLOR][COLOR=blue]$row[/COLOR][COLOR=green][[/COLOR][COLOR=red]'pro_prodart_fld'[/COLOR][COLOR=green]];[/COLOR]
             [COLOR=blue]$sel_bpreisn[/COLOR]     [COLOR=green]=[/COLOR][COLOR=blue]$row[/COLOR][COLOR=green][[/COLOR][COLOR=red]'pro_bpreisn_fls'[/COLOR][COLOR=green]];[/COLOR]
             [COLOR=blue]$sel_prnmwst[/COLOR]     [COLOR=green]=[/COLOR][COLOR=blue]$row[/COLOR][COLOR=green][[/COLOR][COLOR=red]'pro_prnmwst_fld'[/COLOR][COLOR=green]];[/COLOR]
             [COLOR=blue]$sel_npreisn[/COLOR]     [COLOR=green]=[/COLOR][COLOR=blue]$row[/COLOR][COLOR=green][[/COLOR][COLOR=red]'pro_npreisn_fld'[/COLOR][COLOR=green]];[/COLOR]
             [COLOR=blue]$sel_preisalt[/COLOR]    [COLOR=green]=[/COLOR][COLOR=blue]$row[/COLOR][COLOR=green][[/COLOR][COLOR=red]'pro_preisalt_fld'[/COLOR][COLOR=green]];[/COLOR]
             [COLOR=blue]$sel_datum[/COLOR]       [COLOR=green]=[/COLOR][COLOR=blue]$row[/COLOR][COLOR=green][[/COLOR][COLOR=red]'pro_datum_fld'[/COLOR][COLOR=green]];[/COLOR]
    
    	 [COLOR=green]printf ([/COLOR][COLOR=red]"Prod-ID   : %s<br> "[/COLOR][COLOR=green],[/COLOR] [COLOR=blue]$row[/COLOR] [COLOR=green][[/COLOR][COLOR=red]'pro_ID_fld'[/COLOR][COLOR=green]]);[/COLOR]
    	 [COLOR=green]printf ([/COLOR][COLOR=red]"Produkt   : %s<br> "[/COLOR][COLOR=green],[/COLOR] [COLOR=blue]$row[/COLOR] [COLOR=green][[/COLOR][COLOR=red]'pro_produkt_fld'[/COLOR][COLOR=green]]);[/COLOR]
    	 [COLOR=green]printf ([/COLOR][COLOR=red]"Produktart: %s<br> "[/COLOR][COLOR=green],[/COLOR] [COLOR=blue]$row[/COLOR] [COLOR=green][[/COLOR][COLOR=red]'pro_prodart'[/COLOR][COLOR=green]]);[/COLOR]
    	 [COLOR=green]printf ([/COLOR][COLOR=red]"Brut.Preis: %s<br> "[/COLOR][COLOR=green],[/COLOR] [COLOR=blue]$row[/COLOR] [COLOR=green][[/COLOR][COLOR=red]'pro_bpreisn_fld'[/COLOR][COLOR=green]]);[/COLOR]
    	 [COLOR=green]printf ([/COLOR][COLOR=red]"MwSt	   : %s<br> "[/COLOR][COLOR=green],[/COLOR] [COLOR=blue]$row[/COLOR] [COLOR=green][[/COLOR][COLOR=red]'pro_prnmwst_fld'[/COLOR][COLOR=green]]);[/COLOR]
    	 [COLOR=green]printf ([/COLOR][COLOR=red]"Nettopreis: %s<br> "[/COLOR][COLOR=green],[/COLOR] [COLOR=blue]$row[/COLOR] [COLOR=green][[/COLOR][COLOR=red]'pro_npreisn_fld'[/COLOR][COLOR=green]]);[/COLOR]
    	 [COLOR=green]printf ([/COLOR][COLOR=red]"Preis Alt : %s<br> "[/COLOR][COLOR=green],[/COLOR] [COLOR=blue]$row[/COLOR] [COLOR=green][[/COLOR][COLOR=red]'pro_preisalt_fld'[/COLOR][COLOR=green]]);[/COLOR]
    	 [COLOR=green]printf ([/COLOR][COLOR=red]"Datum	   : %s<br> "[/COLOR][COLOR=green],[/COLOR] [COLOR=blue]$row[/COLOR] [COLOR=green][[/COLOR][COLOR=red]'pro_datum_fld'[/COLOR][COLOR=green]]);[/COLOR]
           }
    }
    Aber danke für deinen Tip [COLOR=red]error_reporting ALL[/COLOR] . Das werde ich mir für meine künftigen Arbeiten merken. Das ist ja der Sinn der Sache. Wenn ich Profi wäre, hätte ich keine Beiträge im Forum eingeschaltet. Durch diese rege Kommunikation lernt man ja viel.

    Danke

    Kommentar

    Lädt...
    X