Issues with Dates

slightlyeskew

I'm trying to insert the current date into mysql.
When I try
<?php

$date = date('Y-m-d');
echo "$date";
?>

Prints the date in the correct format, i.e. 2009-9-19.
However when I try
<?php

$date=date("Y-m-d");
$TransactionID=1;
$OtherInfo=blah;
$sql = "INSERT INTO testTable (TransactionID, Date, OtherInfo) VALUES ($TransactionID, $date, $OtherInfo)";

//assume proper connection to $db
$testquery = $db->query($sql);

In mysql this produces

1 | 0000-00-00 | blah

:queasy:

I would appreciate any help you guys could offer.

dagon

$sql = "INSERT INTO testTable (TransactionID, Date, OtherInfo) VALUES ($TransactionID, NOW(), $OtherInfo)";

let mysql do it for you.

rincewind456

You would be better using CURDATE() as it returns a date, in the format YYYY-MM-DD or YYYYMMDD depending whether you use a date field or a string field in your DB, where as NOW() returns a timestamp in the format YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS.uuuuuu, depending on how you use it.

That being said to get your code working you need single quotes around the date variable.