FuelPHP Forums

jonathan

As the title suggest I have a problem using WEEK() sql method
Here's the error message
ErrorException [ Error ]: Call to undefined function WEEK()
and here's my code which fire the error DB::select()
->from($table)
->where_open()
->where(DB::expr(WEEK('created_at')), DB::expr(WEEK(CURRENT_DATE)))
->and_where('language', $lang)
->where_close()
->execute()->as_array();

jonathan

thanks again Harro

Harro

This way week() is seen as a php function. It should be

->where(DB::expr("WEEK('created_at')"), DB::expr("WEEK(CURRENT_DATE)"))

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.

Howdy, Stranger!

Categories

In this Discussion