trouble using where, between and order by clauses

[mystrymaster]

SELECT problem.Battery, problem.County, problem.ERS, problem.Field, problem.CallNum, report.Date, garage.num 
FROM report, problem, garage
WHERE problem.ReportID = report.ID AND problem.SupRead = '1' AND problem.Garage = garage.ID
ORDER BY report.Date,garage.num 
BETWEEN '$_GET[BegDate]' AND '$_GET[EndDate]'

I need to get all those fields sorted by report.date and then garage.num - however it does not seem to be doing that. Is there something I am doing wrong here?

[barand]

Between should be part of the WHERE clause plus you need to specify what is between the dates (report.date?).