Inserting new data into an existing table row

[glimmerwigg]

I'm trying to flag a set of data by putting a value of 'approved' into an otherwise null cell at the end of its row. To do this, I need to include the product ID in the 'tep_db_query(insert into...' instruction. However, I keep getting an SQL syntax error message.

 

I'm obviously doing this completely wrong. Here's an example of the kind of thing I've been trying:

 

tep_db_query("insert into gp_film_for_review where id = .$id. (approved) values ('approved')");

 

any ideas?

 

Thanks!

[glimmerwigg]

Never mind. FYI, answer is:

 

tep_db_query("update gp_film_for_review set approved = 'approved' where id = $id");

 

Thanks