SELECT dat v závislosti na aktuálním čase

TABLE `program` (
  `programID` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  PRIMARY KEY (`programID`)
)

(1, 'Pojďte pane, budeme si hrát', '2011-03-15', '06:30:00')
(2, 'Čertík Lucifuk', '2011-03-15', '07:00:00')
(3, 'Požár v Kocourkově', '2011-03-15', '07:30:00')

$date = date('Y-m-d');
SELECT A.programID, A.title, A.time
FROM program A  
WHERE A.date = '$date'
GROUP BY A.programID
ORDER BY A.date ASC, A.time ASC

(SELECT A.programID, A.title, A.time, A.date
FROM program A  
WHERE A.date > '$date' OR (A.date = '$date' AND A.time > '$time')
ORDER BY A.date DESC, A.time DESC
LIMIT 2)
UNION ALL
(SELECT A.programID, A.title, A.time, A.date
FROM program A  
WHERE A.date < '$date' OR (A.date = '$date' AND A.time <= '$time')
ORDER BY A.date ASC, A.time ASC
LIMIT 2)
ORDER BY `date`, `time`

(SELECT A.programID, A.originalProgramID, A.title, A.time, A.date
FROM program A  
WHERE A.date = '$date' AND A.time > '$time'
ORDER BY A.date ASC, A.time ASC
LIMIT 2)
UNION ALL
(SELECT A.programID, A.originalProgramID, A.title, A.time, A.date
FROM program A  
WHERE A.date = '$date' AND A.time <= '$time'
ORDER BY A.date DESC, A.time DESC
LIMIT 2)
ORDER BY date, time