Re: SqLite INSERT want not write

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


		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, 

Which rights must have the database?

siefke@gentoo-desk db $ ls -l
insgesamt 4
-rw-rw-rw- 1 siefke siefke 4096 19. Apr 21:25 silviosiefke.db


Regards
Silvio

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [Find Someone]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux