Ok, here's the setup. For my University course, I've got a blog set up ( http://addisonrd.com/apu). In the sidebar, you can see the box where I want to be able to list the next assignment due, to help students stay on track. What I don't want to do is have to slice into the template every two days to update it.
Anybody know of a good way to do this? I'd love to be able to just set up a list, or an SQL database, with the list of assignments, links to the files the students need, all by date, then have some code in the sidebar that goes to the list, finds the first event after the current date, and automatically displays it.
Any thoughts? If nothing exists, I might even be willing to hire somebody to write it.