MySQL syntax error

[dsbpac]

This is working for adding a new record

$query = "insert into ucmp_note (owner_id,note,note_time,rel_data,reminder,date_created,create_user_id,create_ip_address,refills,supply,rxname,refilldate,owner_table) values ('$customer_ids','$m_note','$m_note_time','$m_rel_data','$m_reminder','$m_date','$user_id','$m_create_ip_address','$m_refills','$m_supply','$m_rxname','$m_refilldate','$m_owner_table')";
mysql_query($query) or die(mysql_error());

but when I try to update the record using

$query = "UPDATE ucmp_note (owner_id,note,note_time,rel_data,reminder,date_created,create_user_id,create_ip_address,refills,supply,rxname,refilldate,owner_table)  

values 

('$customer_ids','$m_note','$m_note_time','$m_rel_data','$m_reminder','$m_date','$user_id','$m_create_ip_address','$m_refills','$m_supply','$m_rxname','$m_refilldate',

'$m_owner_table')";
mysql_query($query) or die(mysql_error());

its kicking me an error 

 

 

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 'into ucmp_note (owner_id,note,note_time,rel_data,reminder,date_created,create_us' at line 1

[gristoi]

changing the word INSERT INTO with UPDATE wont make the query magically update. read the manual and look at the difference between inserting and updating:

 

http://dev.mysql.com/doc/refman/5.0/en/update.html

[Barand]

Perversely, you can use update syntax as an alternative to normal insert syntax but not vice versa

[dsbpac]

Thanks for pointing me in the right direction guys