Hopefully, I'll get some sketching in afterwards, and the code will cooperate. I fear it's going to take some more unpicking than I'd like, which should probably be done at at time when Sketch Fest isn't running... it is working for now, if somewhat slowly. The new page(s) will be quite sweet, substituting a whole lot of nested looping queries with one single query. But it does mean a new way to record the unregistered users. Who thought it would be nice to allow unregistered participants? Oh, that was me. *facepalm* And I didn't think far enough ahead to set them up seamlessly, so I'm going to need to do some database manipulation, which is always a little stressful.
Urgh, I say!
(But hey, I did learn about LEFT JOIN today, and count() and a few other neat tricks. Plus lots of ways not to use them...)