Jump to content

Archived

This topic is now archived and is closed to further replies.

bilis_money

Inserting data with "where" condition?

Recommended Posts

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.

Share this post


Link to post
Share on other sites
I think you would want to use UPDATE here...

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.