Okay, so, I have a list table with 2 columns: codes and dates.
I want to display the LATEST 25 AND tell the user how long ago they were submitted.
So, for example:
ABCDEF (1 Second Ago)
CCDEE (12 Seconds Ago)
329492 (45 Minutes Ago)
I've gotten this far:
$result = mysql_query("SELECT `code` FROM `fc` ORDER by datetime LIMIT 25") or die(mysql_error());
but, it doesn't do what I want. It does the reverse. It shows what was inputted FIRST, not LAST.
My output looks like this:
$output .= "<li><a href=\"http://www.***=" . htmlspecialchars(urlencode($fetch_array["code"])) . "\" target=\"_blank\">" . htmlspecialchars($fetch_array["code"]) . "</a></li>";
I have NO Idea how to add the (time since) part.
Help?
Thanks :)