updating mysql tables with php

[andz1982]

HI There...

Got a little problem with updating mysql tables...
I have an item that is already in the database (ex. object1) with a product code listed: What i want to do is insert the quantity of items taken of that specific product (the values are being posted from a form; the form is posting just fine but when it comes to actually updating the table it gives an error.

here's an example of what i mean:
(as i mentioned earlier the values are being posted from another form

$sql = mysql_query ("UPDATE products SET quantity_taken=$productquantity1; WHERE product_code='$productcode1'") or die ("UNABLE TO COMPLETE");

(also i want to update the date which is also being posted from another form)
I would really appreciate any help you could give me....


Thanks a lot.

[andz1982]

update.....fixed the problem....small syntax error

[seandisanti]

Good job! Thanks for letting everyone know you resolved the issue also, so we don't go wasting our time suggesting things; if you could though, writing the solution, even if it's just the error you were getting and what was causing it, would help others who may be searching for help with the same error message.