How do I get first timestamp older than 24hours?

sanch

Hi!
Question I am not sure how to even approach... I would like to query results of post timestamps (say 10 results sorted in DESC order) and have it read the timestamp of the most recent... Then go through the remaining 9 results and return the next timestamp that is at least 24 hours (or 86,400 seconds) old or older...

Is an if/elseif/else the only way to do it or is there something more elegant/efficient?

Also, is there a way to stop it if there aren't 10 results available?

I'm not even sure how to organize it... Any tips or solutions?

Sanch

Installer

This should do it:

function get_day_old($ts_arr)
{
    $day_old_ts = strtotime('-1 day');
    for ($i = 1; $i <= 9; $i++) {
        if (!isset($ts_arr[$i])) {
            return false;
        }
        if ($ts[$i] < $day_old_ts) {
            return $ts_arr[$i];
        }
    }
    return false;
}

sanch

Hi Installer!
Thanks for the quick response... I have to admit that I have been staring at the code you supplied and have been trying to figure it out... I can't figure out where does this function fit into the initial query and variables?

I'm sorry for being such a noob... 🙁

Installer

Let's say your query went like this;

$results = mysql_query("SELECT timestamp, etc FROM test ORDER BY timestamp DESC");

You could then put the results into an array:

while ($row = mysql_fetch_assoc($results)) {
    $ts_array[] = $row('timestamp');
}

Get the most recent (topmost) timestamp and remove it from the array:

$most_recent = array_shift($ts_array);

Then pass the array to the function to find the first element that's more than one day old:

$first_day_old = day_old_ts($ts_array);
if ($first_day_old) {
    echo $first_day_old;
} else {
    // Function returned false
}