Re: Help please
| From: | Andrew Etemadi | Date: | Fri, 08 Sep 2000 17:34:36 +0000 |
| Subject: | Re: Help please | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-15916@lists.php.net to get a copy of this message | ||
Use:
UPDATE reminders SET event='test', time='01-01-1999 01:31:00 PM' WHERE recordnum
= 3 AND userid = 4
(replace # with ')
Chris wrote:
> Hi, this may be more of an access question, but I am trying to update a date field with a php
> script and anything I try does not work.
>
> UPDATE reminders SET event='test', time=#01-01-1999 01:31:00 PM# WHERE recordnum = 3
> AND userid = 4
>
> Allways returns an error, I removed the time part and just updated event and it works fine.
> I have tried setting time several different ways, like just 01:31:00 or 01:31 AM or 1:31 AM, I
> tried moving the date after time, I tried removing the date part or changing the date format,
> nothing.
> I just can't see why it won't accept the time value.
>
> the time field is of type Date/Time in the table design, arggggggg.
>
> Thanks for any help.