Jump to content

Problem with db data


mediabob

Recommended Posts

Hi, I am working on a date system like facebook where instead of a date and time something was posted it shows like, 45 minutes ago, or 3 hours ago... that sort of thing and I have it working except for one small issue. To start off I have

 

function post_time ($session_time) {
$db_date = $row_post_list['pdate'];

$calc_time = time() - $db_date;

 

the $db_date should be date/time as pulled from the database, but it does not seem to work. if I replace the  $row_post_list['pdate'] with an actual date/time like this:

 

 

function post_time ($session_time) {
$db_date = 1266048067;

$calc_time = time() - $db_date;

 

The whole thing works flawlessly, so I am not sure what I am doing wrong here. All the rest of the data on the page that comes from the db works great, it's just pulling that one thing that is throwing a wrench in.

Link to comment
https://forums.phpfreaks.com/topic/192480-problem-with-db-data/
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.