Jump to content


Update Syntax $_POST, $_SESSION problem?

  • Please log in to reply
1 reply to this topic

#1 karassik

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

Posted 16 July 2003 - 09:14 PM

I have a problem with the following UPDATE:

$sql=\"UPDATE dlybatchlog_dblog SET check_dblog = 1 WHERE idclinic_dblog = \'\".$_POST[\'idclinic_dblog\'].\"\' AND DATE_FORMAT(date_dblog,\'%m-%d-%Y\') = DATE_FORMAT(NOW(),\'%m-%d-%Y\') AND idcon_dblog = \'\".$_SESSION[\'KT_id_MSSIntranet\'].\"\';\" ;

It works perfectly when I use actual numbers instead of $_POST and $_SESSION vars. Anyone see my mistake? Or suggest a mistake I may be making?

Thanks for looking,


#2 akitchin

  • Staff Alumni
  • Advanced Member
  • 2,516 posts
  • LocationCalgary, AB, Canada

Posted 17 July 2003 - 12:21 AM

include the POST and SESSION values like you would with any other variable (without the string concatenation), and encase the variables in braces like so:


if you don\'t like that idea, you can always localize the variables by going:

$value = $_POST[\'value\'];

and including it in your queries like so:

WHERE idclinic_dblog=\'$value\'

hope this helps, i ran into these problems too.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users