Jan
30
2006
6

Select Last Entries from MySQL

I have a log and I want to list the last time an entry was made by each of the users

SELECT user_id, MAX( log_date ) AS date,
DATE_FORMAT( MAX( log_date ) , "%M, %Y" ) AS english_date
FROM log_table
GROUP BY user_id

I’m not sure if this is the best way. The other options is to use WITH ROLLUP, I didn’t look into that option. This one seems to work, the only iffy part is the MAX(log_date), I may be pushing it just a bit ;)

Written by Aaron Wormus in: Cookbook, MySQL |
Jan
30
2006
0

Wikipedia - Uncyclopedia

Wikipedia - Uncyclopedia

Uncyclopedia’s article on Wikipedia is priceless!

On the NPOV (Neutral Point of View) policy

Also, everyday facts are best presented as general opinion (e.g. “…although it should be kept in mind that no conclusive evidence exists one way or the other, many contend that water is wet, the earth is round, and poking sharpened sticks into your eyes is not a particularly good idea”) Many people believe that this is what many people believe.

Written by Aaron Wormus in: Humor |
Jan
30
2006
0

100 Word Stories

100 Word Stories - IFOC Podcast

Did I already blog about this? Not sure, but it’s a great podcast anyway… a bit morbid, but great stuff!

I just talked to a podcaster I really really like. I’m not talking about email or forums. No, I actually corresponded with him through the messenger! That’s so cool.

But…

He seemed to be too busy to talk to me. That little punk. I think I should torture him. I should tie him up, shove a buffalo burger up his throat, and pour liquid cheese. That would show him, the damn Jew! Wait… I’m a Jew! But that’s okay. I don’t keep kosher. I wish I was able to get some decent bacon in Israel. Or at least some buffalo.

Just one of the many classic bits ;)

Written by Aaron Wormus in: General |

Powered by WordPress | Aeros Theme | TheBuckmaker.com WordPress Themes