next/previous on a date select query

[ade harris]

i have a simple query which returns the next 3 events from todays date

$result = mysql_query("SELECT ID,djs,photo,comments,UNIX_TIMESTAMP(date) AS unixdate FROM test WHERE DATE(date) >= DATE(NOW()) ORDER BY date ASC LIMIT 3", $connection) or die("error querying database");
$i = 0;
while($result_ar = mysql_fetch_assoc($result)){

<?php echo date("l jS F", $result_ar['unixdate']); ?> etc etc

<?php
$i+=1;
}
?>

ID is an auto-incremental field

what i'd obviously like to be able to do is have a previous/next link that shows the prev/next 3 dates from the ones that are currently shown

since the dates entered wont necessarily be in the same order as the ID i cant simply take the id field and add +3 (or whatever)

i cant seem to find anywhere where this has been combined but it must be able to be done ?