What is wrong with this query?
Posted: Sun Jul 11, 2004 8:59 pm
UPDATE nuke_users,
ipb_member_extra SET nuke_users.pn_user_viewemail = 1,
ipb_member_extra.email_full = 0,
ipb_member_extra.email_pm = 0,
ipb_member_extra.allow_admin_mails = 0,
ipb_member_extra.auto_track = 0 where nuke_users.pn_uid = 2 AND ipb_member_extra.id = 2
MySQL said:
You have an error in your SQL syntax near ' ipb_member_extra SET nuke_users.pn_user_viewemail=1, ipb_member_extra.email_ful' at line 1
what is wrong, since the error it gives does not give me any hints :/
ipb_member_extra SET nuke_users.pn_user_viewemail = 1,
ipb_member_extra.email_full = 0,
ipb_member_extra.email_pm = 0,
ipb_member_extra.allow_admin_mails = 0,
ipb_member_extra.auto_track = 0 where nuke_users.pn_uid = 2 AND ipb_member_extra.id = 2
MySQL said:
You have an error in your SQL syntax near ' ipb_member_extra SET nuke_users.pn_user_viewemail=1, ipb_member_extra.email_ful' at line 1
what is wrong, since the error it gives does not give me any hints :/