Difficult MySQL Query?

$query="SELECT * FROM `ticket` WHERE user='id' AND (`date` >= '$date1' AND `date` <= '$date2') ORDER BY id";