Selecting all records from 6:00pm on

[tibberous]

I am programming a site that processes orders. Orders after 6:00 are processed the next day. My client wants a screen that lists "Todays Orders", which are really the orders from 6:00pm yesterday to the present.

 

Any ideas? I'm stumped on this one.

[andrewgauger]

$begin=mktime(18, 0, 0, date("m")  , date("d")-1, date("Y"));
$end=$begin+86400;

 

You might have to throw these at date() to get them formatted for your SQL query.

 

[sniperscope]

<?php

if(date("H:i:s") < '18:00:00'){

    $nextday = 1;

}else{

    $nextday = 0;

}

$i = mktime(0, 0, 0, date("m"), date("d")-$nextday, date("Y"));

?>

 

it may help you.

[dabaR]

Here is an example:

 

"SELECT * FROM orders where order_time between '" . date('Y-m-d 18:00:00', strtotime('yesterday')) . "' AND '" . date('Y-m-d 18:00:00', strtotime('today')) . "';"

 

This is basically same as andrewgauger was saying, but complete and a little clearer, IMHO.