I have never done this before and am having some trouble. Could someone tell me where I am going wrong:
$sql = mysql_query("UPDATE `gigs` (txnid, payment_amount, payment_status, itemid, createdtime) VALUES ( '".$data['txn_id']."' , '".$data['payment_amount']."' , '".$data['payment_status']."' , '".$data['item_number']."' , '".date("Y-m-d H:i:s")."' )WHERE (gigname)=".$data['item_number']."'" , $link);
In case I have gone so far wrong you can't see what I am trying to do I want to update the table 'gigs' with the information sent from paypal, and I want to enter it into the row in gigs where the item number is the same as the gigname.
I tested it without the WHERE and it works fine, just goes onto a different line.
Thanks in advance