Information about inserting and deleting

"Francisco Dalla Rosa Soares" <[email protected]> Mon, 3 Apr 2006 10:15:48 -0300

Newsgroups	gmane.comp.db.mdb-tools.devel
Message-ID	<[email protected]>

Hello everyone,
My name is Francisco and I'm having some trouble here.
I was asked to create a migratory tool from DBF to MDB that would also
be able to run under linux, so I decided for MDBtools with unixODBC.
Now I'm having some problems with insertion and deletion.
My actual code is:

//------------------------------------CODE
START---------------------------------------------------------//

<html>
 <head>
  <title>PHP Database Example</title>
 </head>
<?php
$db = odbc_connect("GDB","","");
$result = odbc_exec($db, "INSERT INTO  Products  VALUES (100, 'Jill',
'555-1040')");
odbc_commit($db);

?>

 </body>
</html>
//------------------------------------CODE
END---------------------------------------------------------//


but I always get this message from the interpreter:

//--------------------message------------------------------//
bash-3.00$ php index.php

<html>
 <head>
  <title>PHP Database Example</title>
 </head>
Error at Line : parse error near INSERT

 </body>
</html>
//--------------------message------------------------------//

Though I can't see errors at all.

Isn't inserting and deleting supported yet?
Am I doing something wrong?


                                thanks in advance,

                                          Francisco Dalla Rosa


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642