SQL error code = -104 Token unknown - line 1, char 188

[chinni_77]

Hello,

what does the error 104 mean?could somebody pls tell me wherez the error in my update statement?

$update_sql = "update TBL_HANDSET SET ".
"HS_IPUI = '{$HTTP_POST_VARS['ipui'][$cntr]}', ".
"HS_TEI = '{$HTTP_POST_VARS['tei'][$cntr]}', ".
"HS_ATTACH = $attach, ".
"HS_DETACH = $detach, ".
"HS_IPUICLASSB0 = '{$HTTP_POST_VARS['ipui_classb'][$cntr]}', ".
"HS_IPUICLASSB1 = '{$HTTP_POST_VARS['ipui_classb1'][$cntr]}', ".
"HS_UAK = '{$HTTP_POST_VARS['uak'][$cntr]}', ".
"HS_LAL = '{$HTTP_POST_VARS['lal'][$cntr]}', ".
"HS_AC = '{$HTTP_POST_VARS['ac'][$cntr]}', ".
"where HS_ID = {$HTTP_POST_VARS['id'][$cntr]}";

[Lars_Berg]

You have a superfluous comma just before where. I.e.

"HS_AC = '{$HTTP_POST_VARS['ac'][$cntr]}', ". // <---
"where HS_ID = {$HTTP_POST_VARS['id'][$cntr]}";

should be

"HS_AC = '{$HTTP_POST_VARS['ac'][$cntr]}' ".
"where HS_ID = {$HTTP_POST_VARS['id'][$cntr]}";

[chinni_77]

wow!
Thanks Berg:-)