Help with Next Up: Event code

[WoosterG]

I would like to have the next event be displayed. I have a 1 week calander on my front page, I have a 2 week calander on another and a full schedule on another.

I have Tables and Fields as schedule.iidtime, schedule.iidgame (auto) and schedule.nopp

I basically would like the next event to be displayed after Next up: Example Opponent on Date at Time

Most likely my iidgames are in the correct order, if not, just a few out of place if that is an easy way to do it.

Thanks