Help with UPDATE datetime
Posted: Fri Jan 31, 2014 5:13 pm
I want to execute an UPDATE query to update a datetime field but I am not getting the desired results!
Here is the query:
The deadline is the datetime field and I am POSTING the dt from a text input. Please help me. Thanks in advance!
Here is the query:
Code: Select all
$result = mysqli_query($con, "UPDATE `tasks` SET `deadline`=".$_POST['dt'].", `status_id`=3 WHERE `task_id`=".$_POST['id']."");