I have a simple update in my PHP that doesn't work. Can you help me spot the err pls:
Code: Select all
$updateQuery = "Update tbl_contribution_payments Set ContributionPaidOK=1, ContributionTotalAmt='".$amtPaid."',
ContributionPaymentRef='".$worldpayref."', ContributionSalesQty=".$salesQty.", ContributionDateTimeStamp=$today4,
ContributionPaymentMethod='WP' Where ContributionID=$contributionID AND PartneringID=".$partneringID ." And ContributionJosUserID=".$joomlaid;
echo '<br>updateQuery '.$updateQuery.'<br><br>';
mysql_query(updateQuery);
Code: Select all
updateQuery Update tbl_contribution_payments Set ContributionPaidOK=1, ContributionTotalAmt='700', ContributionPaymentRef='9830085', ContributionSalesQty=200, ContributionDateTimeStamp=2008-08-31 9:50:11, ContributionPaymentMethod='WP' Where ContributionID=44 AND PartneringID=37 And ContributionJosUserID=460Code: Select all
Field Type Collation Null Key Default Extra Privileges Comment
---------------------------- ----------- ----------------- ------ ------ ------- -------------- ------------------------------- -------
ContributionID int(11) NULL PRI (NULL) auto_increment select,insert,update,references
ContributionJosUserID int(11) NULL YES MUL (NULL) select,insert,update,references
ContributionPartnerJosUserID int(11) NULL YES MUL (NULL) select,insert,update,references
PartneringID int(11) NULL YES MUL (NULL) select,insert,update,references
ContributionUnitAmt float(9,2) NULL YES (NULL) select,insert,update,references
ContributionSalesQty int(11) NULL YES (NULL) select,insert,update,references
ContributionTotalAmt float(9,2) NULL YES (NULL) select,insert,update,references
ContributionType char(1) latin1_swedish_ci YES R select,insert,update,references
ContributionDateTimeStamp datetime NULL YES (NULL) select,insert,update,references
ContributionPaidOK tinyint(4) NULL YES 0 select,insert,update,references
ContributionPaymentRef varchar(10) latin1_swedish_ci YES (NULL) select,insert,update,references
ContributionPaymentMethod char(2) latin1_swedish_ci YES (NULL) select,insert,update,references
Thanks