MySQL Error

[mrpatel]

Hi All,
I am a newbie to MySQL. I am trying to update a table through PHP, but I am getting an error. Could someone please point me what I am doing wrong here??

$cur2 = odbc_exec( $conn_id, "update Rank_Assoc SET rank_id=$RANK, personnel_id = $per_id, date_achieved=$dor, note=$rankNote where rank_assoc_id=$rankAssID");

I am getting the following error:

Warning: SQL error: [MySQL][ODBC 3.51 Driver][mysqld-3.23.47]You have an error in your SQL syntax near 'where rank_assoc_id=' at line 1, SQL state 37000 in SQLExecDirect in c:\program files\apache group\apache\htdocs\proto3\private\change\updatepersontodb.php on line 361

Thanks a lot,
Mehul

[barand]

Date and text variables need 's araound them.

$cur2 = odbc_exec( $conn_id, "update Rank_Assoc SET rank_id=$RANK, personnel_id = $per_id, date_achieved='$dor', note='$rankNote' where rank_assoc_id=$rankAssID");