This is a list for myself so I don't forget. Today I had two finals, and tomorrow I have two more, plus a paper due for one of the classes. So I'm buuusy. Then, Thursday I'm going on a road trip for a week or so to visit my friend Justin in Virginia, and my friend Michelle in North Carolina, and do whatever else to kill a week down in the "south" (quotes for you Matt), and then I'm helping Justin move back home.
So, I left myself Wednesday to get all my "stuff" done I gotta do. So, in no particular order.
- Bring my car into the mechanic so he can check it and make sure it's not going to fall apart on me.
- Get a car wash and oil change
- Figure out what classes I'm going to take over the summer and register (yeah, I know I'm way behind)
- Make sure I have all my laundry done.
- Go to the mall and get my glasses adjusted. They've gotten a little bent out of shape.
- What else?
- Oh yeah, clear my e-mail inbox. I've left some e-mails just plain unanswered.
- Pay my credit card bill
- Change my blog software so that while I'm gone and not blogging I don't have a blank page the whole time.
- As a side note, it's interesting: There are really three possible ways to show N days (I do four) worth of posts. You can show the past four days going back from "today", which is bad if you stop blogging because you run out. You can show four days going back from the last weblog post you had, which is probably better since your page won't go blank on you. Last, you can show the past four days, even if there are "holes" (if you don't blog every day). I'm not sure off the top of my head how to go about saying that in SQL, so that's probably not a great way to go in general, and it's not something I'll be doing. But yeah, I'll be changing my blog software to go to the second of those choices.
- I can't believe I'll be gone for this, but I have to set up my VCR to record the Buffy series finale, and the penultimate episode of 24. Smallville too, but I'll probably be back by next Sunday when they show reruns of that week's shows on the WB.
- Clean my room if I get a shot. It's nice coming home to a clean room. I'm not as motivated as Jeremy is, but I can at least try.
- Mail in my stupid rebate for my stupid video card I shouldn't have wasted money on.
- Back up my dad's computer onto mine. We try to make it a monthly habit, in addition to his daily backups, staggered on one CD-RW for each day, plus a pair, one of which he keeps "off site" at a time. What's on his computer is far too important to lose.
- Don't know if I got a shot, but I'd like to at least try to finish up my StructuredText parser (the Python version), and maybe upload it to my site so if I'm bored and we're not doing anything cool and we're sitting around Justin's place, or if he's asleep at 3 in the morning when I can't sleep, maybe I can work on it.
Monday, May 12, 2003
Permalink
RE showing the last X days, I use the third option. As far as I can tell there's no way of doing it in a single mySQL query so I use two: The first query grabs the most recent 6 unique TO_DAYS() results from my entries table, and the second grabs all entries whos TO_DAYS is in the set of results returned by the first one:
select entries.* ... where TO_DAYS(added) in (10203, 10205, 10206, 10209)
Something like the above anyway. The array used for the in bit can be easily created with PHP's implode() function.