QUOTE(Trogdor @ 31 Jul, 2008 - 09:44 AM)
Are you sure there are entries in that table between now and October?
If so, you may have to start fiddling with date-math functions (dateadd etc)
As a side note, it is bad style to use any form of quotes in table or column names, and you have both `game_date` and game_date (without quotes) in your query.
I'm positive that there are dates in there. The October date is actually the final date. I was told by a friend to try order by Descending(?), and also to try naming the alias something other than the column name. Problem is, I'm not sure which one is the alias for the game_date column...is it the one in the dateformat parentheses or the one after the AS?
As far as the quotes, I copied and pasted that straight from the markup that PhPmyAdmin was providing. I'm new to this and don't know when to use quotes and when not to.
31 Jul, 2008 - 08:43 AM
|