Re: SqLite INSERT want not write
| From: | Stuart Dallas | Date: | Thu, 19 Apr 2012 18:58:15 +0000 |
| Subject: | Re: SqLite INSERT want not write | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-317627@lists.php.net to get a copy of this message | ||
On 19 Apr 2012, at 19:52, Silvio Siefke wrote:
> On Thu, 19 Apr 2012 13:21:46 -0500
> tamouse mailing lists <tamouse.lists@gmail.com> wrote:
>
>> Maybe this will make the syntax errors stand out more:
>>
>> http://dl.dropbox.com/u/571329/Screenshots/Picture%209.png
>
>
> ok i have change it to the function date, but now i has the error
> message:
>
> PDOException: SQLSTATE[HY000]: General error: 1 SQL logic error or missing database
>
> gentoo-desk ~ # php -l test.php
> No syntax errors detected in test.php
>
> The script now -> http://nopaste.info/63fe0a9148.html
Using date() is not valid there. It's possible now() might work (don't use PDO so I dunno
for sure), otherwise you'll need to bind that parameter in the same way you're binding the
others.
-Stuart
--
Stuart Dallas
3ft9 Ltd
http://3ft9.com/
