formato data in php da mysql

$result = mysql_query("SELECT `datetime` FROM `table`");$row = mysql_fetch_row($result);$date = date_create($row[0]);

echo date_format($date, 'Y-m-d H:i:s');#output: 2012-03-24 17:45:12
echo date_format($date, 'd/m/Y H:i:s');#output: 24/03/2012 17:45:12
echo date_format($date, 'd/m/y');#output: 24/03/12

mysql datediff

$query = $query . " dataCompetizione>=now() and  DATEDIFF(dataCompetizione,now()) <= 8 ";

date php

$oggi=time();
echo 'oggi: '. date('Y-m-d', $oggi) ."<br>";
$oggi=$oggi   + (20 * 24 * 60 * 60);
echo 'oggi + 20: '. date('Y-m-d', $oggi) ."<br>";
echo 'oggi + 20: '. date('d/m/Y', $oggi) ."<br>";