[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?

[tippy_102]

If I'm reading what you want to do correctly, I would do an UPDATE

 

UPDATE coupons SET paid = paidvalue, location = $location WHERE couponID='$couponID