update help wanted

[Smifffy]

is there any way to modify a single cell in a database with some new info like this

$query = "INSERT INTO news(content) VALUES('$content') WHERE id = $id";

would that work if not what would do it?

thanks

[devinemke]

$query = "UPDATE news SET content = '$content' WHERE id = $id";

[Smifffy]

how would i do that with multipul fields????

[devinemke]

$query = "UPDATE news SET
content = '$content',
first_name = 'John',
last_name = 'Smith',
email = '[e-mail]'
WHERE id = $id";

[Smifffy]

thanks
hehe

i put the same post on another site and i just got the same answer

hehe

[devinemke]

i guess "John Smith" is a popular guy

[Smifffy]

no the actual method to do it

thanks for the help mate