note 68463 deleted from function.date by felipe
| From: | felipe@php.net | Date: | Sun, 09 Dec 2007 14:18:34 +0000 |
| Subject: | note 68463 deleted from function.date by felipe | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-133016@lists.php.net to get a copy of this message | ||
Note Submitter: rev at NOSPAMO dot returntothepit dot com
----
the CORRECT MySQl datetime format is
<?php
$date = "Last Saturday";
date("Y-m-d H:i:s",strtotime($date));
$sql = "INSERT INTO pictureusageindex (
subject,date) VALUES
('$subject','$date')";
echo "$sql<br>";
?>
a person who posted above is wrong. leaving out the "-"