You dont understood my problem

Code:
$result = $oDatabase->Query('SELECT `Start_date`, `End_date`, `Booking_id`, `Description`, (DATE_FORMAT(NOW(), \'&#37;Y-%m-%d %H:%i:%s\') BETWEEN `Start_date` AND `End_date`) as `is_now` FROM `bookings` WHERE DATE_FORMAT(NOW(), \'%Y-%m-%d %H:%i:%s\') < `End_date` '.(($zaal > 0) ? 'AND `Product_id`='.$zaal.' ' : '').'AND`Description` IS NOT NULL ORDER BY `Start_date` ASC LIMIT 7');
this code works.
however i must ROTATE the events.
the current event must be in the middle.
and below that must be a few earlier events in order
and above that musta be a few later events in order.

it must rotate