Hello Experts,
Very simple... i would like to enter the current date & time into my MS SQL DB, Field: LastMapUpdate using PHP.
My existing code is below, please advise how to modify for the desired results.
Thanks in advance.
$sql = sprintf("UPDATE Routes SET EstDistance=%f, EstHours=%d, " .
"EstMins=%d, FinishDate='%s', FinishTime='%s', ReMap=0 WHERE ID=%d",
$cmdObject->totaldist, $cmdObject->totalhours, $cmdObject->totalmins,
$runfinishdate, $cmdObject->runfinishtime, $cmdObject->runid);
$res = $MyDB->ExecQuery($sql);
Open in new window