Update Query (syntax?) problem?

[karassik]

Hello,

 

I\'ve been trying to get this query to work all morning and I think it has a syntax problem. Anyone agree?

 

Nishan

 

$sql=\"UPDATE dlybatchlog_dblog SET clsmnth_dblog = \'\".$_POST[\'dropdate\'].\"\', idclinic_dblog = \'\".$_POST[\'idclinic_dblog\'].\"\', runnum_dblog = \'\".$_POST[\'runnum_blog\'].\"\', charges_dblog = \'\".$_POST[\'charges\'].\"\', adjustments_dblog = \'\".$_POST[\'adjustments\'].\"\' WHERE idclnblog_dblog = \'\".$_POST[\'id_clnblog\'].\"\' \";

[shivabharat]

Try this

 

$sql="UPDATE dlybatchlog_dblog SET clsmnth_dblog =\'$_POST[\'dropdate\']\', idclinic_dblog = \'$_POST[\'idclinic_dblog\']\', runnum_dblog = \'$_POST[\'runnum_blog\']\',charges_dblog =\'$_POST[\'charges\']\', adjustments_dblog = \'$_POST[\'adjustments\']\' WHERE idclnblog_dblog = \'$_POST[\'id_clnblog\']\'";