MySQL Forums
Forum List  »  PHP

can't figure out what is wrong that updates first field but not the rest.
Posted by: Keith Moffitt
Date: September 09, 2016 05:09PM

//Execute the Search String
$sql = "";
$sql = "UPDATE customers ".
"SET TimesPurDL = '$tot_tms_dl' ".
", reldDtOne = '$reldDtOne' ".
", reldDtTwo = '$reldDtTwo' ".
"WHERE CCnumber = '$ccdigits' ".
"AND Purdate = '$PurDate'";

if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}

Options: ReplyQuote


Subject
Written By
Posted
can't figure out what is wrong that updates first field but not the rest.
September 09, 2016 05:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.