Update syntax is :
UPDATE <table name> SET <field name 1>=<field value 1>,<field name
2>=<field value 2>
etc
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> 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: ""<[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> >> Sent: 20 February 2001 13:08
> >> To: [EMAIL PROTECTED]
> >> 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: [EMAIL PROTECTED]
> >> For additional commands, e-mail: [EMAIL PROTECTED]
> >> To contact the list administrators, e-mail:
> >> [EMAIL PROTECTED]
> >>
> >>
> >
> >
>
> _____________________________________________
> Free email with personality! Over 200 domains!
> http://www.MyOwnEmail.com
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
