Another way to update with SQL?

[inkfish]

Hello,

When im editing (updating) for example my news, i update the new values into the mysql database like this:

"UPDATE mc_news SET headline='$headline', news='$news', news_type='$news_type' WHERE id='$news_edit_id'"; 

Aren't there a way to do it like when you do INSERT with the
("Text","text","Text") VALUES ("Value","Value","Value")?? It would be much nicer then doing it with the Something='Text', Something='Text';

Thanks!

[yelvington]

UPDATE changes an existing record.

INSERT creates a new record.

In either case, you can use the notation

INTO tbl_name (col1,col2) VALUES(val1,val2);

... or

INTO tbl_name SET col1=val1, col2=val2;

It's entirely up to you. Use the one that you find the most convenient and easily understood.

[inkfish]

GReat! =) Thanks!

[su1d]

if id field is a primary key in the table (what it should be by all means), you may use

"REPLACE INTO table_name SET id=$id, foo='bar'"