Extracting MySQL timestamp

[t_galan]

Hello,

I've managed to extract a MySQL timestamp row and beautify the output.
The only problem is that the time is updating automatically when I refresh the web page.
I'm not sure if my problem is in php or mysql but I know the time does not autoupdate when I remove the formating so I suspect I'm not actually getting the time from MySQL with formating enabled.
Any leads would be greatly appreciated.

Thanks

$year = substr($row[$i], 0, 4);
$month = substr($row[$i], 4, 2);
$day = substr($row[$i], 6, 2);
$hour = substr($row[$i], 8, 2);
$min = substr($row[$i], 10, 2);
$sec = substr($row[$i], -2);
$date = date('M d, Y', time($month, $day, $year));
$time = date('H:i:s', time($hour, $min, $sec));

printf ("$date@$time",
		$row[$i],
		htmlspecialchars ($row[$i]));

[devinemke]

you are misusing the [man]time[/man] function, it does not take arguments like that. i suspect you are confusing [man]time[/man] with [man]mktime[/man].

anyway, don't use PHP to do the formatting, do it in mySQL using the DATE_FORMAT function.