Peter J. Boettcher — Mon, 05 Nov 2001 13:56:29 +0000

You could probably go ahead and use that same query. Then just use DateDiff inside you loop to build the different even sections.

Example:

<?php
 do while not rs.eof 
?>

<?php
 If DateDiff("d", Now, rs("Date")) > 7 Then
strEventTitle = "Future events" 
?>

<?php
 If strEventHolder <> strEventTitle Then Response.Write strEventTitle & "<br>"
?>

<?php
= rs("event") 'display stuff here 
?>

<?php
 ElseIf DateDiff("d", Now, rs("Date")) <= 7 Then
strEventTitle = "Upcoming Events 
?>

<?php
 If strEventHolder <> strEventTitle Then Response.Write strEventTitle & "<br>"
?>

<?php
= rs("event") 'display stuff here 
?>

<?php
 Else 
strEventTitle = "Past Events 
?>

<?php
 If strEventHolder <> strEventTitle Then Response.Write strEventTitle & "<br>"
?>

<?php
= rs("event") 'display stuff here 
?>

<?php
 End If 
?>

<?php
 strEventHolder = strEventTitle 
?>

<?php
rs.MoveNext loop 
?>

Because your query is sorted by date desc this should work.