Jump to content

Time from DB


steveangelis

Recommended Posts

I have my table withthe column timestamp and I am trying to retreive the date and it is how showing up correct.

 

 

Here is my code:

 

 

$pmq = mysql_query("select *, UNIX_TIMESTAMP(time_sent) AS FORMATED_TIME from pm where user_to=".$_COOKIE['id']." order by id asc");

 

That is the query to get the date.

$pmft=mysql_result($pmr,0,"FORMATED_TIME");

 

$date=date("g:s, t M, Y",$pmc['time_sent']);

 

I echo the date and I get this error and to be honest I am beyond confused with this.  All I want it to do is echo the date and I know it is stored correctly.  Where am i going wrong?

 

 

Link to comment
https://forums.phpfreaks.com/topic/156042-time-from-db/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.