I already have a script set up to pull data from my database. I have a DATE row. I want to be able to change the format of the displayed date on the page from something such as "2004-01-06" to "Jan 06, 2005". I've searched everywhere and still can't seem to find out exactly how to do this. Can anyone help me out here?
Here's the code I'm using:
$dbcnx = @mysql_connect("localhost", "sonicpl_sncpla", "*******");
if (!$dbcnx) {
echo( "Unable to connect to the " .
"database server at this time." );
exit();
}
if (! @mysql_select_db("sonicpl_sncpla") ) {
echo( "Unable to select database!" );
exit();
}
$result = mysql_query(
"SELECT * FROM site_games");
if (!$result) {
echo("<P>Error performing query: " .
mysql_error() . "</P>");
exit();
}
// Display the text of each joke in a paragraph
while ( $row = mysql_fetch_array($result) ) {
echo("<a href=\"../games.php?id=".$row["id"]."\"><b>".$row["title"]."</b></a> - ".$row["usa_release"]."<br />".$row["intro"]."<br /><br />");
}