Hi,
I'm having some problems with the following:

$query = "SELECT * FROM table ORDER BY date DESC";
$result = mysql_query($query);
$result_row = mysql_fetch_assoc($result);
$time = strtotime($result_row['date']);
$date = date("F jS, Y g:i:s A", $time);
echo $date;

So, if say one row in my database had a date TIMESTAMP of 20050214120000, it should display as February 14th, 2005 12:00:00 PM. Instead, the code displays all row dates as December 31st, 1969 3:59:59 PM. Can someone help me with this or point me in a direction. Thanks!

Your timestamp is not in unix form, and that is what date is expecting. Feb 14 is actually 1108339200 (seconds since 1970 I think?)

Instead of using the "date" function, you need to split your string, as the first 4 are year, then month etc...

Use the substr function instead:

http://us4.php.net/manual/en/function.substr.php

camperjohn,

Thank you for responding. I will take a look at the substr function and give that a try. Thanks!