Re: Re: Can't to insert data ( via variable ) into MS-SQL
| From: | Rob Adams | Date: | Sat, 27 Mar 2004 16:19:45 +0000 |
| Subject: | Re: Re: Can't to insert data ( via variable ) into MS-SQL | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-181614@lists.php.net to get a copy of this message | ||
<edwardspl@ita.org.mo> wrote in message news:4064E216.7B23CFE1@ita.org.mo...
> Rob Adams wrote:
>
> > <edwardspl@ita.org.mo> wrote in message
news:40644F7C.D1639531@ita.org.mo...
> > > $str = " INSERT INTO staff (name,job,subject)
> > 1 2 3
> > >
> > > VALUES('$name','$job','$date','$subject',)";
> > 1 2 - 3
>
> $date=date('Y-m-d H:i:s');
>
> Any idea for me to fix this kind of problem ?
I guess I wasn't explicit enough. I would start by chaning your insert
statement to:
insert into staff (name, job, date_field, subject) values ... (etc.)
-- Rob