time date

[robmann]

the following worked fine with mysql

$posted_time=date("D, m/j/Y, G:i A", $row->time);

Tue, 02/15/2005, 12:42 PM

need to change to work with mysqli

$posted_t=$row_result['time'];
$posted_time=date("D, m/j/Y, G:i A", $posted_t);

the output is always

Wed, 12/31/1969, 19:00 PM

is there a different format for this using mysqli?

database info
bigint, 11, unsigned
cell data the coresponds to the above output
1108489373

[Weedpacket]

That would happen if $posted_t (i.e. $row_result['time']) equalled zero, and the server was five hours east of Greenwich. No, there isn't a different format for mysqli.