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 :/
What is wrong with this query?
Moderator: General Moderators
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
UPDATE Syntax wrote:Starting with MySQL 4.0.4, you can also perform UPDATE operations that cover multiple tables:Code: Select all
UPDATE items,month SET items.price=month.price WHERE items.id=month.id;
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
you can run a VERSION() query, or run phpinfo() to find out definitively
Code: Select all
SELECT VERSION()Code: Select all
<?php phpinfo(); ?>