karassik Posted June 10, 2003 Share Posted June 10, 2003 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\'].\"\' \"; Quote Link to comment https://forums.phpfreaks.com/topic/571-update-query-syntax-problem/ Share on other sites More sharing options...
shivabharat Posted June 10, 2003 Share Posted June 10, 2003 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\']\'"; Quote Link to comment https://forums.phpfreaks.com/topic/571-update-query-syntax-problem/#findComment-1919 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.