[Wolves] mysql select help

[Wayne Morris]

Hi,
Got a working database with list of items and the date(s) on which they 
occur.
Already set up so I can search a particular date and display all the 
records.

trying to find a way to 'display all the records that occur on the next 
date when something happens'
and ignore all the stuff on days thereafter.
So I can have a button that on click displays '6 items on Friday 30th'

been scratching my head all morning, any ideas?

Cheers