[PHP-DB] Updating a value usins MsAccess db?

[Tom]

I was just wondering if anybody knew how to update values using an access
db? (using odbc_exec()?). I have it all setup to display the results, just
cant seem to update it, I always get errors. Heres my code:

if($da != 0)
 {

  $cnx = odbc_connect( 'a' , $u, $p );
   if( ! $cnx )
     { echo "Error in odbc connect"; }

  $cur= odbc_exec( $cnx, "UPDATE weekno SET Date=$da" );
   if( ! $cur )
   { echo "Couldnt return curser"; }



  odbc_close( $cnx);

  $dat =  $da;

 }

I get

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error
in UPDATE statement., SQL state 37000 in SQLExecDirect in
c:\inetpub\wwwroot\dbtest.php on line 19

thanks
--tom



-- 
PHP Database 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]