I am using the PHP date function like this:
but I am getting a very odd date..saying 08/20/70...here is the time stamp that it is using.
I am trying to get that to a readable date like this:
and in the database (MySQL) it is timestamp(8)
You'll need to use MySQL functions instead of PHP functions. date() takes a unix timestamp which is usually a number like 992670321 which is the number of seconds since the unix epoch or Jan 1, 1970.
You want to do this
now $row["date"] will have it in the format you want
$result = mysql_query("SELECT DATE_FORMAT(date, '%m/%d/%Y') as date from tablename");
Check out http://mysql.he.net/documentation/my...time_functions for more information