how to execute the query that include date function(MySQL)

Question

I got a query including two variable parameters. It cannot be executed successfully. Anyone help me to have a look. thanks

$queryUpdateScreeningMaileddate = "UPDATE screening
     SET maileddate = {date('Y-m-d', strtotime($mailed_date[$screeningId]))}
      WHERE user_id IN (  
                     select s.id
                     from (
                         SELECT users.id
                         FROM users
                         INNER JOIN screening ON 
                         users.id = screening .user_id
                         AND screening.id = {$screeningId}
                          ) as s)
       AND date BETWEEN '2011-05-15' AND '2011-11-15'";

   $_db->executeQuery($queryUpdateScreeningMaileddate);

Maybe you want to use "... SET maileddate = ".date('Y-m-d', strtotime($mailed_date[$screeningId]))."..." ? — martin.malek
– martin.malek, Commented Sep 13, 2011 at 14:28

DaveRandom · Accepted Answer · 2011-09-13 14:27:55Z

2

Curly brace {} syntax only works for variables, it doesn't work for function calls. You will have to break the string up like this:

$queryUpdateScreeningMaileddate = "UPDATE screening
     SET maileddate = '".date('Y-m-d', strtotime($mailed_date[$screeningId]))."'
      WHERE user_id IN (  
                     select s.id
                     from (
                         SELECT users.id
                         FROM users
                         INNER JOIN screening ON 
                         users.id = screening .user_id
                         AND screening.id = {$screeningId}
                          ) as s)
       AND date BETWEEN '2011-05-15' AND '2011-11-15'";

   $_db->executeQuery($queryUpdateScreeningMaileddate);

answered Sep 13, 2011 at 14:27

DaveRandom

88.8k11 gold badges159 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to execute the query that include date function(MySQL)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related