Use of date function in PHP to output a user-friendly date
- by Jamie
I have a MySQL database column named DateAdded.
I'd like to echo this as a readable date/time.
Here is a simplified version of the code I currently have:
$result = mysql_query("
SELECT ListItem, DateAdded
FROM lists
WHERE UserID = '" . $currentid . "'
");
while($row = mysql_fetch_array($result))
{
// Make the date look nicer
$dateadded = date('d-m-Y',$row['DateAdded']);
echo $row['ListItem'] . ",";
echo $dateadded;
echo "<br />";
}
Is the use of the date function the best way to output a user-friendly date?
Thanks for taking a look,
