How to format the date differently that MySQL's default

[matar84]

I am using the Date ( ) method in MySQL that makes the dates like this YYYY/MM/DD.

How can I edit the following script below to display the date as $myformat = date("F j, Y); instead?

<?php

$dbcnx = @mysql_connect("localhost", "username", "password");
if (!$dbcnx) {
  echo( "<p>Unable to connect to the " .
        "database server at this time.</p>" );
  exit();
}

if (! @mysql_select_db("eqlounge_news") ) {
  echo( "<p>Unable to locate the review " .
        "database at this time.</p >" );
  exit();
}

$result = @mysql_query("SELECT id, short_story, date, subject FROM news_posts ORDER BY id DESC LIMIT 15");
if (!$result) {
  echo("<p>Error performing query: " . mysql_error() . "</p>");
  exit();
}

  while ($row = mysql_fetch_array($result) ) {
  $id = $row["id"];
  $short_story = $row["short_story"];
  $date = $row["date"];
  $subject = $row["subject"];
  echo ("<a href=\"news/?id=$id\">$subject</a> - $date<br />\n$short_story<br /><br />\n\n");
}

?>

[matar84]

Someone was trying to assist me and came up with this, but I could not integrate it into my code correctly. Either that or this snippet itself is just wrong:

$datecomponents = explode("-", $date); // datecomponents[0] = year, [1] = month, [2] = day
$myformat = date("F j, Y", mktime(0, 0, 0, intval($datecomponents[1]), intval($datecomponents[2]), intval($datecomponents[0])));

[Weedpacket]

Could you not use MySQL's DATE_FORMAT() function? Just a thought; if you're storing a date in a MySQL date field it seems reasonable to use MySQL date functions to manipulate it...

[Duey]

thx weed needed that