On Tue, Apr 24, 2007 at 10:03:58AM -0700, Chris W. Parker wrote:
UPDATE `users`
SET `name` = 'First Last'
AND `email` = '[EMAIL PROTECTED]'
AND `balance` = 0
AND `accrual` = 14400
AND `is_manager` = 1
AND `is_superadmin` = 1
AND `type` = 0
AND
On Tuesday, April 24, 2007 10:12 AM Jim Winstead mailto:[EMAIL PROTECTED]
said:
AND `type` = 0
AND `manager_id` = 0
AND `modified` = NOW()
WHERE `id` = 5
you can't use 'AND' to connect your updates, you need to use commas:
UPDATE users SET name = 'First Last', email =
