Inserting data with "where" condition?

[bilis_money]

hi, i would like to insert data with "where" condition is this correct codes
below?

[code]
$query = "INSERT INTO photos (comments) VALUES ('$comment_tmp') where ID = '91';
[/code]

I want to insert the $comment_tmp into comments only on ID = 91.
Is this correct or wrong?
Please correct me if i'm wrong.

thank you very much in advance.

[GingerRobot]

I think you would want to use UPDATE here...

$query = "UPDATE photos SET comments='$comment_tmp' WHERE id='91';

[wildteen88]

You'll want to use an UPDATE statement rather than an INSERT statement. INSERT creates a new row into the database. Where as UPDATE can change fields within an existing row

[brown2005]

yes update

[bilis_money]

ok, i'll try that thanks!

[Newbiephper]

sry to use this post but it will get my point across

$query = "UPDATE photos SET comments='$comment_tmp' WHERE id='91';

what would happen if you wanted to use the 'id' from one table to update data in tanother table.

i.e. u have 2 tables

user data (this contains id)
table x ( you want to update data in this table for that particular user)

thx any help