Jump to content


Photo

Update Syntax $_POST, $_SESSION problem?


  • Please log in to reply
1 reply to this topic

#1 karassik

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,

Nishan

#2 akitchin

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:

{$_POST[\'value\']}

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