Hi All I am trying to format the sql ouput reg_date into a date format current details echoed out 2013 - 03 - 08 12:12:11 I just require the date only
echo stripslashes($row['reg_date'])
$result = $mysqli->query($query) or die ($mysqli->error.__LINE__);
if($result->num_rows > 0)
{
while($row = $result->fetch_assoc())
{
echo stripslashes($row['reg_date']) . " " . stripslashes($row['centre_name'])."<br>";
}
else
{
echo "No results found";
}
mysqli_close($mysqli);
Thanks in advance
D