Any Ideas about occuring events between dates

[meHere]

I have a script written to find all events that occur between two dates,
the first date is entered and then the next number of days and the end date is calculated from this.

I can find all events which begins between these two dates by using:

$dbQuery = "SELECT * FROM Events WHERE EventDate between '$startDate' and '$endDate' ";

but how can I find events which may not begin but are occuring between these two dates I tried using

$dbQuery = "SELECT * FROM Events WHERE EventDate between '$startDate' and '$endDate' or".
"EventDate <= '$startDate' AND EventEndDate >='$endDate'";

but it doesn't work have you any ideas?

Thank-you

[zhabala]

$dbQuery = "SELECT * FROM Events WHERE ( EventDate between '$startDate' and '$endDate' ) or ( EventEndDate between '$startDate' and '$endDate' ) or ( EventDate <= '$startDate' AND EventEndDate >='$endDate' )";

[meHere]

Thank you very much zhabala it works just as I need it