Re: SqLite INSERT want not write

["siefke_listen@xxxxxx" <siefke_listen@xxxxxx>]

		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