Ok, I have some code where I do a querry from a MYSQL DB and output the results. One of the columns in my table is the date, in the MYSQL format YYYY-MM-DD. It works fine, but I would like to have the output formatted as: October 18th 2000 (for example). How do I modify my querry to accomplish this? Here is a snippet of my code:
$query = "SELECT * FROM tips WHERE ".id." LIKE '%".$tipnumber."%'";
$result = @mysql_query($query);
if (!$result) {
echo("<p>Error performing query: " . mysql_error() . "</p>");
exit();
}
echo("<center>"."<strong>"."<A HREF=\"searchtechdb.php?marque=$marque&category=$category&keyword=$keyword&radio=$radio&password=$password\">Return</a>"."</center>"."</strong>");
$row = mysql_fetch_array($result);
echo("<strong> #".$tipnumber." Title: "."</strong>");
echo("<u>");
echo(htmlspecialchars(stripslashes($row["title"])));
echo("</u>");
echo("<br />");
echo("Applicable marque: ");
echo(htmlspecialchars(stripslashes($row["marque"])));
echo("<br />"."Submitted by: ");
echo(htmlspecialchars(stripslashes($row["member"])));
echo("<br />"."Date submitted: ");
echo ($row["date_col"]);
echo("<br />"."Category: ");
echo(htmlspecialchars(stripslashes($row["category"])));
echo("<br />"."Tip Narrative: ");
echo nl2br(htmlspecialchars(stripslashes($row["tip"])));
echo("<p />");
Thanks Basil
