The `payment` and `payment_date` fields do not update, and do not throw an error. Any ideas?
Code: Select all
if (isset($_POST['submit']))
{
$x = $_POST['payment'];
if ( is_int($x) )
{
$y = date("Y-m-d");
$payment = trim($_POST['payment']);
$display_name = trim($_POST['display_name']);
$phone1 = trim($_POST['phone1']);
$phone2 = trim($_POST['phone2']);
$email = trim($_POST['email']);
$query = "UPDATE `users` SET `payment_date`= '".$y ."'";
$query .= " `payment`='".$payment."', `phone1`='".$phone1."',`phone2`='".$phone2."',`email`='".$email."'";
$query .= " WHERE `display_name`='".$display_name."'";
mysql_query($query, $connection) or die(mysql_error());
$message = 'User was edited successfully' ;
}