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.
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);
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 4 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.