Jump to content


Photo

Update Query (syntax?) problem?


  • Please log in to reply
1 reply to this topic

#1 karassik

karassik
  • Members
  • PipPip
  • Member
  • 13 posts
  • LocationPortland, Oregon

Posted 10 June 2003 - 08:32 PM

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\'].\"\' \";

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 10 June 2003 - 11:23 PM

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\']\'";

Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users