Problem with Select in Codeigniter

[eluser]CroNiX[/eluser]
I also answered this in his other (this is a duplicate) post. In addition to the identifiers issue, the parameters passed to date_format ('% W% M% Y') is totally wrong.

1) it starts with a %, with no specifier
2) MySQL uses the % before the specifier, but the poster is doing it backwards (W% instead of %W)
3) there is a 'Y' by itself

http://dev.mysql.com/doc/refman/5.1/en/d...ate-format