SQL statement with date(W) in it.

[inkfish]

Hello,

I only want to show the records where the field "week" is == the week that is right now.

I tried this:

$question_query = "SELECT * FROM mc_questions WHERE week = $date(W) ORDER BY question_type";

I get this errorr message:

Unknown column 'W' in 'where clause'

Thanks!

[hand]

$question_query = "SELECT * FROM mc_questions WHERE week = week(now()) ORDER BY question_type";

WEEK(date,first)
With a single argument, returns the week for date, in the range 0 to 53 (yes, there may be the beginnings of a week 53), for locations where Sunday is the first day of the week.
More ...
http://www.mysql.com/doc/en/Date_and_time_functions.html

[inkfish]

Great 😉 Worked perfecto!

Thanks!