|
Posted by Bob Stearns on 10/14/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;";
Navigation:
[Reply to this message]
|