I have been asked to produce an alphabetical list of courses in work, which I did and it was easy using the MySQL ORDER BY yada ASC.
However, as usually happens in cases like this, the boss wants this list split into individual pages with a menu of links for ABCDEFGH etc, so clicking H would bring up all the Healthcare modules etc.
I have done those googlesc 123456 etc lists of links before using the href's as triggers for a LIMIT BY query, but alphabetical lists are a different kettle of fish altogether. My solution so far is to run a cron job every night to build the static html pages for each letter and just serve these to the browser, this does not make me happy, and I am sure there is a better solution, but it has me stumped.
I am searching fruitlessly for an image of the sole of an acupuncture trainer that was featured on Radio One this morning. Some woman bought her kid a pair of trainers, got them home and realised that the soles had images of teddy bears in various states of arousal emblazoned across them, with the words, 'If you go down to the Woods today you're in for a big surprise'.