PHP MS-Access odbc_exec() gives 'too few parameters' error

[JoeNinja]

Im failing to update the an MS ACcess. I will appreciate Your advice. I get the error below

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect in C:\Program Files\Apache Group\Apache2\htdocs\Test\Thomas\HelpDesk\UpdateAs sign.php on line 27

Here is the script that is generating the error.

<?php
 
$conn=odbc_connect("HELPDESK","" ,"");
 
 
     $surname = $_POST['SurNametxt'];
     $firstname = $_POST['firsNametxt'];
     $station = $_POST['Stationtxt'];
     $jobtitle = $_POST['JobTitletxt'];
     $datelogged = $_POST['DateLogtxt'];
     $complaint = $_POST['compl'];
     $status = 'A'; 
     $priority = $_POST['Priortxt'];
     $technician = $_POST['Techtxt'];
     $priority  = "$priority";
 
 
if (!$conn)
       {exit("Connection Failed: " .$conn);}
 
$update = "update hdsk_complain
SET  hd_com_priority = $priority
Where hd_com_jobtitle= 'SDM'";
 
 
 
$result = odbc_exec($conn, $update);
 
 
 
if (!$result) {exit('Execution failed!');} 
 
     odbc_close($conn);
?>

[pbmods]

Heya, Joe. Welcome to TSDN!

Please use CODE tags when posting source code. See the REPLY GUIDELINES on the right side of the page next time you post.

Changed thread title to better describe the problem (did you know that threads whose titles contain phrases such as, 'problem' actually get FEWER responses?).

[code green]

Too few parameters. Expected 1

Using ODBC this usually means you have an incorrect field name.
I am not saying this is a definition of the error.
Just that in my experience this is the problem.
So the problem may be your query

update hdsk_complain
SET  hd_com_priority = $priority
Where hd_com_jobtitle= 'SDM'";