The drive back to Blacksburg, VA from Northern Virginia can get old pretty fast. I stopped at JMU and walked around for a bit, and while I was at it... took some pictures :-) . I've only gone out in JMU once but it was a crazy night with my best friend Richard, and we ended up faking accents and going to multiple parties and all kinds of goodness.
Random Handstands with MySQL and CSS Fix
Well, it turns out that the “Random” handstands you see on the right were actually not all that random. They weren’t showing any from my roadtrip or beyond which was puzzling. I still don’t know exactly why that code didn’t work, but I have some that does now, which is less efficient (but works)!
For anyone who is a MySQL guru, I wanted to determine the MAX id, and then generate a random id off of that. Then using that id, retrieve the information.
I accomplish it by making 2 calls now:
- Call 1 (Getting a Random id):
- SELECT FLOOR(MAX(id) * RAND()) FROM `$this->table` LIMIT 1
- Call 2 (Getting the properties out for that id):
- SELECT `id`, `title`, `description`, `small` FROM `$this->table` WHERE id = $rand_id ORDER BY id LIMIT 1
How do I make a query that works in one shot, but accomplishes the same thing?
My About page was looking messed up as the footer came up and swallowed the entire page. I ended up fixing that thankfully though too. Yay for fixes!