12-17-2009, 03:34 AM
(This post was last modified: 12-17-2009, 03:35 AM by manipulate.)
Hey,
I'm working on a new site (http://www.programminglife.net/) and I've came across a bit of a problem, I'm not sure how to explain it using 'generic' MySQL terms so I'll just tell you what is happening, without giving you too much information on what the site is actually going to be.
The site allows users to submit snippets of code, on the front page I have a 'Latest Snippet' section set up, what I want to know is how to actually find out which snippet is the 'latest' one there, I have a column in the 'snippets' table that holds the current timestamp (which appears to be in the YY/MM/DD HH:MM:SS format) for each snippet, I can grab these but I have no idea what to do with them, how exactly do I find out which one is the latest snippet?
Reply ASAP, It's kind of a brick wall for me and I can't really do anything until it's fixed.
Thanks.
I'm working on a new site (http://www.programminglife.net/) and I've came across a bit of a problem, I'm not sure how to explain it using 'generic' MySQL terms so I'll just tell you what is happening, without giving you too much information on what the site is actually going to be.
The site allows users to submit snippets of code, on the front page I have a 'Latest Snippet' section set up, what I want to know is how to actually find out which snippet is the 'latest' one there, I have a column in the 'snippets' table that holds the current timestamp (which appears to be in the YY/MM/DD HH:MM:SS format) for each snippet, I can grab these but I have no idea what to do with them, how exactly do I find out which one is the latest snippet?
Reply ASAP, It's kind of a brick wall for me and I can't really do anything until it's fixed.
Thanks.