Can anyone tell me what I am doing wrong with this update statement? I am using Apache/PHP4 and Access 2000. Many thanks.
<?
$cnx = odbc_connect( 'vehicle' , '', '' );
if( ! $cnx )
{
Error_handler( "Error in odbc_connect" , $cnx );
}
$stmt = "update vehicle set regNumberID = '$regNumber',
catID = '$info[catID]',
vehicleDescripID = '$descripID',
vncoID = '$tirePressureRear',
where vehicleID=$vehcleID";
$ins= odbc_exec($cnx, $stmt);
odbc_close( $cnx);
?>
<?
$cnx = odbc_connect( 'vehicle' , '', '' );
if( ! $cnx )
{
Error_handler( "Error in odbc_connect" , $cnx );
}
$stmt = "update vehicle set regNumberID = '$regNumber',
catID = '$info[catID]',
vehicleDescripID = '$descripID',
vncoID = '$tirePressureRear',
where vehicleID=$vehcleID";
$ins= odbc_exec($cnx, $stmt);
odbc_close( $cnx);
?>