I have a datebase of events. I have a form that adds to it, and I have a
form that removes from it (with checkboxes). And I have a php file that
will view all the events, either all of them or just the events happening
after "today." These events are added randomly, and I want my php file that
views the events to display the results in order of when they are happening.
Any suggestions? I have seen a CREATE VIEW query that looks promising. Is
that a good way to do it, just to create an on-the-fly table that is sorted
and display the reults from that one?
Thanks,
Paul