Help retrieving date in proper format!

[Anon]

I have the following snippet:

---

printf("<table> \n");
$result = mysql_query("SELECT * FROM ssb_members ORDER BY m_member",$db);
while ($myrow = mysql_fetch_array($result)) {
  printf("<tr><td><a href=\"%s?Autonum=%s\">%s</a> \n", $PHP_SELF, $myrow["m_number"], $myrow["m_firstname"]);
  printf("</td><td>%s</a>", $myrow["m_lastname"]);
  printf("</td><td>%s</a>", $myrow["m_member"]);
  printf("</td><td>%s</a></td></tr>", $myrow["m_lastmod"]);
}

---

This grabs info out of my database and formats it in a simple table. What it is also doing is formatting the date in UNIX standard (988090779), as that is how the date is stored.

How do I get it to show the DATE instead of the integer? I am still planning on using the above format.

Thanks all.

[dolce]

Looks a lot like a Unix Timestamp to me... you can pull a normal date directly out of the mysql database, go to www.mysql.com and read the manual on the DATE_FORMAT funtcion... To get a valid date out of this, you may do something like:

SELECT DATE_FORMAT(indat,"%d - %m - %Y) AS m_lastmod FROM sometable

dolce