Steffan A. Cline wrote:
> I have the following query:
>
> select *,
> if( season_week_date = "2006-08-16", "on", "off" ) as stat,
> sum(overall_points) as total_points
> from rosters r
> left join celebs c
> on c.celeb_id = r.celeb_id
> where
> season_id=5062
> and user_id=1
> group by r.celeb_id
> order by overall_rank, ln, fn;
>
> It almost works as expected however the problem I am concerned about is that
> I never get a stat saying "On" after it resolves. Removing the sum() and
> adding group I get the total_points as expected but now the results are
> always off.
Remove the "if" first and make sure the rest of the query returns the
results you expect.
That will tell you either the query isn't working the way you want, or
the if check isn't working.
Is season_week_date only a date or is it a date/time field?
If the query isn't working the way you want, can you post relevant table
schemas and 5 rows of data from each and what you expect to get?
