Select with where (date) condition

Anon

i get an error with this:

$feb = February;
$query = "SELECT date, number, title, count, date_format(date, '%b %e, %Y') AS readable_date, MONTHNAME(date) AS month from journal WHERE month='$feb'";

if i take out the where condition, it prints ok. why, oh why? i need to select only a specific month from my db using monthname (ie February etc). i would use date_format, but it doesn't display %n as a monthname. i did a search for date and time in selects, but found no info including the where condition. so i am lost.

how can i limit by monthname?

BIG THANKS in advance for clues/help/advice or anything at all,
anne

Anon

I believe the problem is that you can not used aliases in the WHERE clause of your SQL query.... It should work if you change your query to this:

$feb = "February";
$query = "SELECT date, number, title, count, date_format(date, '%b %e, %Y') AS readable_date, MONTHNAME(date) AS month FROM journal WHERE MONTHNAME(date)='$feb'";

Hope this helps,
-JoshB

Anon

YOU ARE MY HERO! what you suggested worked like a charm. You've made my night!

Many Thanks,
Anne 😃

Anon

No Problem 🙂

-JoshB

Anon

hi,
just alter this in your query:
$feb = February;
$query = "SELECT date, number, title, count, date_format(date, '%b %e, %Y') AS readable_date, MONTHNAME(date) AS month from journal WHERE MONTHNAME(date) ='$feb'";