On Thu, Apr 19, 2012 at 12:40 PM, siefke_listen@xxxxxx
<siefke_listen@xxxxxx> wrote:
> Hello,
>
> On Thu, 19 Apr 2012 15:17:06 -0400
> "Steven Staples" <sstaples@xxxxxxxx> wrote:
>
>> Ok, so I was wrong... ;) it does happen
>>
>> Try this:
>> $sql = "INSERT INTO bloggen (date, autor, title, teaser, content)
>> VALUES ('" . date('Y-m-d H:i:s') . "', :autor, :title,
>> :teaser, :content);";
>
> No errors, but no entry in the database.
>
>
>> Or
>> $sql = "INSERT INTO bloggen (date, autor, title, teaser, content)
>> VALUES (NOW(), :autor, :title, :teaser, :content);";
>
>
> PDOException: SQLSTATE[HY000]: General error: 1 no such function: NOW
>
> Now is not availible in Sqlite, can use date,
>
Technically, it's date('now') per [1] :) RTFM FTW!
http://www.sqlite.org/draft/lang_datefunc.html
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
