[bitesize]

Nevermind, problem solved by avoiding the complexities of those functions

Final query used that worked:

Code:

$e_query = mysql_query( "SELECT fnID, fnEventCategory, DATE_FORMAT(fdDateTime, '%l:%i') as time, fnHomeTeamID, fnAwayTeamID, fnHomeTeamScore, fnAwayTeamScore FROM tblGame, tblEvent WHERE fnEventID = fnGameID AND fdDateTime > '$e_query_date' AND fdDateTime < '$e_query_uDate' ORDER BY fdDateTime ASC" );