Excuse me while I “squee!” in geekish glee/delight.

One problem in eFiction is that the display order for the categories occasionally gets messed up. I gave up trying to fix them by hand a long time ago and just had Jasson give me a cheap and dirty work-around.

Well, tonight I came up with a solution all on my own. Sorry, this gets pretty geeky from here on out.

I made a query to the database, asking for all the subcategories in alphabetical order. I then created a while loop that took those 337 results and wrote SQL update statements for me. I offset the count by 9, since I don’t want to reorder the main categories since they’re okay right as they are.

And boom! 337, neat little MySQL update statements that reordered the categories for me. ^_^

There are times where I look at all the designs other people are doing and feel decidely inferior. This just suddenly made me realize just how far I’ve come and how much I’ve learned.

And it feels very good. ♥