Posted by Bob Stearns on 10/09/71 11:29

charliefortune wrote:
> I would like to update two fields with a single query. Is this possible
> ? I am having no success with ;
>
> $query = "UPDATE product SET price=$newprice,tracking_url=$newtracker
> WHERE ASIN = $product_asin;";
>
That should work; I suspect a lack of apostrophes. Try

$query = "UPDATE product SET price=$newprice,tracking_url='$newtracker'
WHERE ASIN = $product_asin;";

[Back to original message]