And The Winner Is…

You’ll be pleased to know that I have calculated a winner! I used the power of mighty MySQL to pull all names from the comments table, group by email (to eradicate duplicates) remove those who could not/did not want to enter and randomise the results. Everyone was assigned a number and I save the output as an HTML file (which you can see here.)

I asked the random number generator to give me a number between 1 and 123, and was given 24. That means that Annie (comment is here) of ikillhearts is the lucky winner! Congratulations Annie, I will be contacting you shortly with details of how to claim your t-shirt.

Thank you to all who entered — I got more interest than I expected and the rush of comments in one go led me to discover a few badly optimised bits of code (thanks MySQL max_connections) in my system. Nonetheless it was interesting, and I hope to do it again some time.

14 Comments

  1. Oh, so you totally went with my method, hmmm?

  2. Woo scary. It was almost the number 23! Congrats, Annie!

  3. Jem

    01 Jul at 9:37 am

    Oh, so you totally went with my method, hmmm? Kinda :p

  4. Karl Entwistle

    01 Jul at 2:15 pm

    We needs pictures of the winner posing with her new T-shirt ;)

  5. That came out more perverted than expected……

  6. @Karl: or before (no shirt) and after (with shirt) pictures :D

  7. Darn! I just realized… I’m #24, congrats Annie anyway. :]

  8. I can’t believe I won, thanks! @ Karl: I’ll definitely put a picture of me with it on my site when I get it :)

  9. Congratulations Annie! Cool contest Jem!

  10. Congratulations, Annie! :)

  11. Congrats Annie, enjoy the t-shirt :) Thanks for running the contest Jem!

  12. Congratulations Annie :)

  13. Not only does she get a tshirt, she gets a plug. I’d almost rather get the plug! haha

  14. Congratulations, Annie! :)