RE: [PHP-WIN] PHP4 and MS Access
| From: | Gregory_Griffiths at cargill dot com | Date: | Tue, 20 Feb 2001 15:04:51 +0000 |
| Subject: | RE: [PHP-WIN] PHP4 and MS Access | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-5659@lists.php.net to get a copy of this message | ||
Update syntax is :
UPDATE <table name> SET <field name 1>=<field value 1>,<field name
2>=<field value 2>
etc
> -----Original Message-----
> From: glenn@yeayea.com [mailto:glenn@yeayea.com]
> Sent: 20 February 2001 14:27
> To: griffiths, gregory d. /here
> Subject: RE: [PHP-WIN] PHP4 and MS Access
>
>
> Hallo!
>
> OK
> But I must update a record in the tabel , but i get the same
> error msg.
>
> result = odbc_exec($connect, "UPDATE content '$tblIngress'= '$tblTest'
> where id = $id");
>
> Best regards.
> //Glenn
> ----------------------------------------------
> Original Message
> From: ""<Gregory_Griffiths@cargill.com>
> Subject: RE: [PHP-WIN] PHP4 and MS Access
> Date: Tue, 20 Feb 2001 14:16:11 +0000
>
> >You don't need a WHERE clause on an insert
> >
> >> -----Original Message-----
> >> From: glenn@yeayea.com [mailto:glenn@yeayea.com]
> >> Sent: 20 February 2001 13:08
> >> To: php-windows@lists.php.net
> >> Subject: [PHP-WIN] PHP4 and MS Access
> >>
> >>
> >> Hallo!
> >> I try to make an insert statment but get a ERROR msg, It
> >> looks like this
> >>
> >>
> >> Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]
> >> Syntax error
> >> in INSERT INTO statement., SQL state 37000 in SQLExecDirect in
> >>
> >> my insert statment look like this:
> >>
> >> /* run insert */
> >> $result = odbc_exec($connect, "INSERT INTO content (ingress,
> >> text) VALUES
> >> ('$tblIngress', '$tblText') where id = 1");
> >>
> >> pleas help me
> >>
> >> Best regards
> >> //Glenn
> >>
> >> _____________________________________________
> >> Free email with personality! Over 200 domains!
> >> http://www.MyOwnEmail.com
> >>
> >>
> >> --
> >> PHP Windows Mailing List (http://www.php.net/)
> >> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
> >> For additional commands, e-mail: php-windows-help@lists.php.net
> >> To contact the list administrators, e-mail:
> >> php-list-admin@lists.php.net
> >>
> >>
> >
> >
>
> _____________________________________________
> Free email with personality! Over 200 domains!
> http://www.MyOwnEmail.com
>
>