Odbc

[freebsd_dude]

Hello All,

I am trying to update a Access2000 database with php and iis 5.

Here is the problem: I need to update only to are three rows out a five row table at a time. Some times i will need to update all the fields. But most of the time the other fields will need blank data.

Here is what i tried and did not work.
$id = odbc_connect("cool","admin","test");
$query = "insert into users (firstname, lastname, date, time) values ('bozotime', 'coolnessdude', 'callspace', 'timer')";
$result = odbc_exec($id, $query);

with the following error:
PHP Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in c:\website\TMPrmkwi7f4wn.php on line 4

THank you all,

[Plakhotnik]

Check fields type. I think you never insert 'callspace' into datatime field.

[freebsd_dude]

There all fields are text.

[Lars_Berg]

date and time are reserved words, rename the columns.

[blindlizard]

Or put brackets around them: [date], [time]

[freebsd_dude]

Thank you the brackets worked.