[SOLVED] Quick Query Question

[Asperon]

so if I want to to do an insert query on a specific already created row, would the syntax be like this?

 

mysql_query = "INSERT INTO coupons(paid,location) VALUES('0','$location') WHERE couponID='$couponID'";

 

thus paid and location information is inserted in to the coupons table with the rows that have $couponID as a their couponID right?

 

or is there a different way that you are supposed to do it?

[Asperon]

I wasn't getting any answers in the mysql forum so I came here, but I guess its busy today at phpfreaks..

[Jessica]

No, you do an UPDATE, not an INSERT.

[Asperon]

I thought there was something else other than insert but I couldn't seem to find it, thank you

[Asperon]

so would it be

 

$query_add = "UPDATE coupons SET location='$location' WHERE couponID='$couponID'";

 

??

[Jessica]

Yep.

[Asperon]

thank you