Problem mit SELECT-Anweisung für mySQL

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #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

    Comment

    Working...
    X