Although officially I hate PHP, date() is pretty cool. The thing is that PHP uses a different timestamp format to the standard MySQL timestamp. Therefore the majority of timestamps stored in MySQL are actually stored as intergers. Or at least this is how phpBB do it. And that is how my latest site does it. But enough about quick plugs. What’s happening here?
Ah right, the thing about MySQL timestamp is that it updates to the current time everytime you update the column. Therefore when I had to make a change to the database to set a post to a different user, it updated the timestamp and moved the post to the top. Hmm, I posted this, maybe it evens it out or at least dislodges it from the top.
So, Malcolm in the Middle has just ended. Ok, here I am just trying to fill out space. Here’s a picture of Fonze again:
Don't have time to check my blog? Get a weekly email with all the new posts. This is my personal blog, so obviously it is 100% spam free.
This entry was posted on Sunday, July 11th, 2004 at 2:19 pm and is filed under Life. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.