Jump to content

Archived

This topic is now archived and is closed to further replies.

karassik

Update Syntax $_POST, $_SESSION problem?

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.