The PHP-MySQL programming loop…

Seriously. I hate writing applications that consist entirely of

// get result set with mysql_query
//  check if there are any results
     //  loop through each result
          //  output its data
//  no results?
     //  output message saying so

Once you’ve mastered that you can get hundreds of freelance jobs and securely say you have the prerequisite skills. It’s just so dull after writing it a hundred thousand times. Oh, that and

//  has this form field been set?
     //  yes, update database

That’s everything. I want something more interesting. I expect this is why Rails was made because someone got sick of doing this.

Last night’s happiness involved a gun, and some mutant rats

Just off the bat, I’m getting really annoyed my my mysqld dieing all the time. I’ve no idea what’s causing it, except that maybe WordPress (which seems to be the only affected thing at the moment) is a little too intensive for my 64Mb server.

Database dieing was the reason I didn’t do last night’s happiness update, but I’ll do it now.

Yesterday’s most happiest thing for me was probably getting Fallout 3 for my xbox. That game is freaking awesome. It seems huge and expansive, however I’m worried that – because things don’t respawn (at least, I don’t think they do. There’re still dead bodies lying around that I killed in-game days ago) – I’ll kill everything and then won’t be able to level up any more. Last night, the stupid Brotherhood of Steel guys killed half of the Raiders before I had a chance.

I only found out you can queue up attacks in the VAT thing a few hours into playing…

I bought Ghost Recon too, but I don’t really like it, so I’m putting it on ebay. I only need one bid to get my money back, to be fair, and I think people will be looking to collect as many game as they can during the holidays. Especially with people getting new xboxes and stuff for Christmas.

Oh, and be spontaneous

I’m going to bed now, but before I do I want to write up what I should be doing tomorrow:

  • More work on KoA, specifically…
    • User profiles page
    • High score table for the one and only game that’s currently on there
    • Switch the Inventory page to use Prototype (at least)
  • Find out how to fix the MySQL/VB problem
  • Find out have to fix “5 clients are using or haven’t closed the table properly” problem that MySQL has on Trinity, and exactly what causes it. (Start here.)
  • Write chapter six of my database design portfolio out
  • Wash up, and wash clothes
  • Write out a better plan for my VB tutorials