Access and updating with PHP

Anon

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);
?>

Anon

hi there

I think no error in Update part (Access2000 query).

Can you tell me the error messege?

Anon

I am getting the following error: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement., SQL state 37000 in SQLExecDirect in

Anon

hi ,...

I am sure there is no error in Update Part.If you want to make sure desgin query in your database to update Record in your table.

I think the problem in your connection.

Are you sure from your connection?

Anon

I'm a newbie at odbc, so bear with me if i'm totaly wrong.

Perhaps the last comma has something to do with it?
$tirePressureRear', <-- that one

I think this would work, but not tested:

$stmt = "UPDATE vehicle SET regNumberID='$regNumber',catID='$info[catID]',vehicleDescripID='$descripID',vncoID='$tirePressureRear' WHERE vehicleID=$vehcleID";

Anon

I am also new to PHP and the only thing I found wrong is the last comma which some one had already pointed out.

Can anyone tell me what I am doing wrong with this insert statement? I am using Apache/PHP4 and Access 2000. The last field of the Movies table is called Image and it is supposed to be a picture from the movie and for now I am not filling up that field. I tried putting "" there and it did not work so I decided to put nothing there. This is the error:
Parse error: parse error in F:\users\williamk\ProcessNewMovie2.php on line 38.

Line 38 is where the print statement starts
thanks.

//set up the connection for Movies
$connID = odbc_connect("MovieCat","","");
$query = "Insert into Movies values ($MovieID, $Title, $GenreIDfk, $ReleaseDate, $Description, $Director, $Starring);
$queryID = odbc_exec($connID, $query);
odbc_free_result($queryID);
odbc_close($connID);
print ("<B><CENTER><FONT COLOR=RED>The New Movie Had been entered Into the Database.</FONT></CENTER></B>\n");

Anon

hi,...
try this in your query

$query = "Insert into Movies values ('$MovieID', '$Title', '$GenreIDfk', '$ReleaseDate', '$Description', '$Director', '$Starring');