PHP and Microsoft Access

[pargie11]

Hey,
I wanted to find out if any of you know the odbc equivalent to mysql_query

I'm using a Microsoft Access DB and need to insert values into a table
ex....
mysql_query("insert into cart(cookieId, MaterialListID, qty) values('" . GetCartId() . "', $MaterialListID, $qty)");

[devinemke]

read up on the ODBC Functions

[pargie11]

Reading's over-rated...ok..maybe not. well anyways...the way i figure the odbc_execute or odbc_exec....are one of the equivalents. But I get an error while running that script

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in c:\Inetpub\wwwroot\mactel communications\cart.php on line 53

[Doug_G]

Probably you need to give the web server user account write permissions to the Access .mdb file.