Hi ich versuche mit PHP einen SQL-Befehl auszuführen, aber irgendwie klappt es auf einmal nicht mehr. Schaut ihr mal bitte, ob ihr was seht, was falsch ist:
SQL-Befehl:
UPDATE users SET Nickname='#empty', GroupMember=5, Vorname='Sascha' , Nachname='schulz', Email='RyanTabbot2003@web.de', Geschlecht='male', Geburtstag='1988-09-13' , Land='Germany', Stadt='Berlin', Homepage='', IsRegistered= , Userbild='', Signature='', AboutMe='', Squad='--', Functions='Forum-Admin Server-Admin Webmaster ' , ICQ='' WHERE Nickname='#empty';
Fehlermeldung:
Fehler
SQL-Befehl :
UPDATE users SET Nickname = '#empty',
GroupMember =5,
Vorname = 'Sascha',
Nachname = 'schulz',
Email = 'RyanTabbot2003@web.de',
Geschlecht = 'male',
Geburtstag = '1988-09-13',
Land = 'Germany',
Stadt = 'Berlin',
Homepage = '',
IsRegistered = ,
Userbild = '',
Signature = '',
AboutMe = '',
Squad = '--',
Functions = 'Forum-Admin Server-Admin Webmaster ',
ICQ = '' WHERE Nickname = '#empty'Stadt = 'Homb',
Homepage = 'www.de.de',
IsRegistered = ,
Userbild = 'www.picture.de',
Signature = 'signature bla blasdfgasdf',
AboutMe = '',
Squad = '--',
Functions = 'Forum-Admin Server-Admin Webmaster Sponsoring ',
ICQ = '3333333377777' WHERE Nickname = 'admin'
MySQL meldet:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '
Userbild = '',
Signature = '',
AboutMe = '',
Squad = '--',
SQL-Befehl:
UPDATE users SET Nickname='#empty', GroupMember=5, Vorname='Sascha' , Nachname='schulz', Email='RyanTabbot2003@web.de', Geschlecht='male', Geburtstag='1988-09-13' , Land='Germany', Stadt='Berlin', Homepage='', IsRegistered= , Userbild='', Signature='', AboutMe='', Squad='--', Functions='Forum-Admin Server-Admin Webmaster ' , ICQ='' WHERE Nickname='#empty';
Fehlermeldung:
Fehler
SQL-Befehl :
UPDATE users SET Nickname = '#empty',
GroupMember =5,
Vorname = 'Sascha',
Nachname = 'schulz',
Email = 'RyanTabbot2003@web.de',
Geschlecht = 'male',
Geburtstag = '1988-09-13',
Land = 'Germany',
Stadt = 'Berlin',
Homepage = '',
IsRegistered = ,
Userbild = '',
Signature = '',
AboutMe = '',
Squad = '--',
Functions = 'Forum-Admin Server-Admin Webmaster ',
ICQ = '' WHERE Nickname = '#empty'Stadt = 'Homb',
Homepage = 'www.de.de',
IsRegistered = ,
Userbild = 'www.picture.de',
Signature = 'signature bla blasdfgasdf',
AboutMe = '',
Squad = '--',
Functions = 'Forum-Admin Server-Admin Webmaster Sponsoring ',
ICQ = '3333333377777' WHERE Nickname = 'admin'
MySQL meldet:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '
Userbild = '',
Signature = '',
AboutMe = '',
Squad = '--',
Kommentar