Syntax Issues

covert215

I can't figure out what the syntax error for this statement is:

UPDATE users_info SET email = 'email@aol.com',
group = 'abc',
cong = 'abc',
msn = 'testing',
yim = '',
aim = '',
address = 'My Address',
icq = '',
phone = '555-555-5555',
zip = '55555',
show_email = '1',
show_profile = '1',
WHERE id = '1'

I enter the statement directly into phpMyAdmin and I receive the error:

MySQL said:
#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 'WHERE id ='1'' at line 13

Installer

Delete that comma and see what happens.

covert215

That code now works in phpMyAdmin, but not in my program...I'll explore the code a bit more.

[edit]In fact, it even says that it works in my program (no errors) but there is no change in the database....

covert215

I have it working now....instead of typing the query as a quote into mysql_query(), I stored it as a variable and then used it. I'm not quite sure what it did, but everything is working now.

bradgrafelman

Since we're talking abount syntax here anyway, make sure that columns with numeric types (id columns, for example) are given numbers - not strings (meaning don't surround the number in quotes).

planetsim

well there could be several reasons what code are you using in your application small snippet would do. Secondly does this record exist and if so is there anything to actually update. If the record exists and doesnt update it probably means the record doesn't need to be updated with the new field values as it already has them, use [man]mysql_affected_rows[/man] to see (will just return how many rows the query affected). I dont see any obvious errors.