Problem using custom value in query 1

[solepixel]

It's been a while since I wrote a "complicated" query and I can't figure out why this isn't work:

$querydate = "2007-07";

$query = "SELECT *,
   DATE_FORMAT(`date`,'%M %e, %Y') AS disp_date,
   DATE_FORMAT(`date`, '%m-%d') AS sDate,
   DATE_FORMAT(`date`, '%Y-%m') AS querydate
  FROM `testimonials`
  WHERE `deleted` <> 1 AND
   querydate = '".$querydate."'
  ORDER BY `winner` DESC,
   `sdate` DESC";

When I try this, I get an unknown column "querydate". Can you not use a variable created within the query in the WHERE part? Am I doing something seriously wrong?

 

[jpadie]

as you allude, i don't think you can reference created vars like that.

i would do what you are trying to do as follows

$year = '2007';
$month = '7';
$query = "SELECT *,
   DATE_FORMAT(`date`,'%M %e, %Y') AS disp_date,
   DATE_FORMAT(`date`, '%m-%d') AS sDate,
   DATE_FORMAT(`date`, '%Y-%m') AS querydate
  FROM `testimonials`
  WHERE `deleted` <> 1 AND
   year(`date`) = '$year' AND
 month(`date`) = '$month'
  ORDER BY `winner` DESC,
   `sdate` DESC";

 

[solepixel]

ah, thank you so much jp for reminding me how to do this properly...