SlyFox
Новичок
подскажите с выводом даты, в базе храниться дата в фортаме 1291112180 BIGINT как с помощью MySQLi_Result можно сделать вывести в нормальном виде день: месяц: год на Mysql получалось так
mysql_connect ("$host:$port","$user","$pass");
mysql_select_db ("$DB1");
mysql_query("SET NAMES $database_encoding");
$uptime = mysql_query ("select max(`starttime`) from `uptime`");
$uptime = time()-mysql_result ($uptime,0);
$sec = $uptime%60;
$uptime = intval ($uptime/60);
$min = $uptime%60;
$uptime = intval ($uptime/60);
$hours = $uptime%24;
$uptime = intval($uptime/24);
$days = $uptime;
echo "<b>$block[12]</b> $days d $hours h $min m <br>";
mysql_connect ("$host:$port","$user","$pass");
mysql_select_db ("$DB1");
mysql_query("SET NAMES $database_encoding");
$uptime = mysql_query ("select max(`starttime`) from `uptime`");
$uptime = time()-mysql_result ($uptime,0);
$sec = $uptime%60;
$uptime = intval ($uptime/60);
$min = $uptime%60;
$uptime = intval ($uptime/60);
$hours = $uptime%24;
$uptime = intval($uptime/24);
$days = $uptime;
echo "<b>$block[12]</b> $days d $hours h $min m <br>";