If you haven't already noticed, I added a "recent comments" section down to the right. The goal is to have it show all recent entries (those whose parent post still shows on the main page), grouped by post, showing the most recent entry for each post. Problem right now is that I can't figure out how to get the most recent entry for each post before it groups by the entry, so it's showing the first comment for each entry.
Curses! I think it's impossible to do what I want to do without using sub-selects. I've been poring over my SQL book tonight, and I haven't found a solution. I'll have to write procedural code to do it.
Hey, at least PHP allowed me to write functional-style code, thanks to in_array() and array_push().
Feel free to post a comment below. Please see my comment policy.
Formatting Rules (No HTML):