[Select record closest to this time yesterday]

Solved it, used PHP as I had to use it anyway.

 

function minutes_round ($hour, $minutes = '5', $format = "H:i")
{
    $seconds = strtotime($hour);
    $rounded = round($seconds / ($minutes * 60)) * ($minutes * 60);
    return date($format, $rounded);
}


$yesterdayDate = date("Y-m-d", mktime(0, 0, 0, date("m"),date("d")-1,date("Y")));
$time = date( 'H:i:s');

$time = minutes_round($time);

[Select record closest to this time yesterday]

I have a database that inserts a record every 5 minutes, 24/7. I want to easily retrieve the closest record to the current time - 1 day. Could somebody point me into the right direction please.

 

[Simple Active Inactive Icon]

Cheers, I think I know what has to be done, now that I know what way I should be doing it. Before I was thinking some form of text file with every status separated by a comma and then reading the text file into an array, and yeah making it terribly complicated.

[Simple Active Inactive Icon]

So far neither, I'd just do HTML but as i'm still learning i'm open to options, and am I correct in thinking I should chuck it in a DB with a column for active/inactive?

 

EDIT: By the way, the table isn't terribly large, max of 15 - 20 items.

[Simple Active Inactive Icon]

I've been browsing the foams for a while now but haven't posted until now. Anyway,

 

I have a table containing a list of items, I want a column to have either a red or a green icon depending on the state I set manually. My question is, how would I best set this up? I'd like to be able to have a simple checkbox admin page that when saved the other page reflects the state either 0 (inactive) or 1 (active), what would be the best way of storing these values and then reading them again? By this I mean a text file, MySQL, etc.

 

I have some knowledge of PHP and MySQL, though not a massive amount.