Hello,
I'm having a problem when trying to update a record. I'm trying to set a
field called 'balance' to 0 but instead of 'balance' becoming 0 the
field 'name' becomes 0. None of the other columns are updated
incorrectly.
Here's the SQL statement I'm using:
UPDATE `users`
SET `name` = 'First
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 =