Need help related to my codeigniter wallpaper script

GROUP BY should be the last statement in database queries.

Code:

Syntax:

The syntax for the GROUP BY clause in MySQL is:

SELECT expression1, expression2, ... expression_n,
      aggregate_function (expression)
FROM tables
[WHERE conditions]
GROUP BY expression1, expression2, ... expression_n;

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )