if(date("H")<7))
{
$var1 = 1;
$var2 = 0;
}
else
{
$var1 = 0;
$var2 = 1;
}
Then use this query:
SELECT dtg FROM techs WHERE tech='$user' AND (TO_DAYS(dtg) =
TO_DAYS(CURRENT_DATE) - $var1 DAY AND HOUR(dtg) > 7) AND (TO_DAYS(dtg) =
TO_DAYS(CURRENT_DATE) + $var2 DAY AND HOUR(dtg) < 7)
I _think_ that works, but don't have a table to test it on. Let me know
if it does. If it's before 7 am, it'll get all records between 7 am
yesterday and 7 am today. If it's after 7 am, it'll get all records
between 7 am today and 7 am tomorrow.
---John Holmes...
> -----Original Message-----
> From: Thoenen, Peter Mr. EPS
> [mailto:Peter.Thoenen@bondsteel2.areur.army.mil]
> Sent: Friday, October 11, 2002 12:34 AM
> To: php-db@lists.php.net
> Subject: easier way to do this? (time interval)
>
> Hello,
>
> Curious if there is an easier way to do this (using just SQL and not
PHP).
> SQL seems powerful enough to do this but can't think of the synatx.
Note,
> I
> am using MySQL so no sub-selects (or other useful items). Basically
> trying
> to pull all records for a 24 hour period but instead of 0000->2400,
> 0700->0700 (next day).
>
> if (date("H")>7){
>
> $query=mysql_query("
> SELECT dtg
> FROM techs
> WHERE
> tech='$user'
> AND
> DAYOFMONTH(NOW())=DAYOFMONTH(dtg)
> AND
> HOUR(dtg)>=7
> ");
>
> } else {
>
> $query=mysql_query("
> SELECT dtg
> FROM techs
> WHERE
> tech='$user'
> AND
> (
> (DAYOFMONTH(NOW())=DAYOFMONTH(dtg) AND HOUR(dtg)<7)
> OR
> ((DAYOFMONTH(NOW())-1)=DAYOFMONTH(dtg) AND HOUR(dtg)>=7)
> )
> ");
>
> }
>
> Cheers,
>
> -peter
>
> ##################################
> Peter Thoenen - Systems Programmer
> Commercial Communications
> Camp Bondsteel, Kosovo
> ##################################
>
> "Stumbled Upon"...heh (Score:5, Funny) /.
> by $carab on 23:00 23 August 2002 (#4131637)
>
> "ForensicTec officials said they stumbled upon the military networks
about
> two months ago, while checking on network security for a
private-sector
> client."
>
> Someone new to a Dvorak probably tried to type in "lynx
> http://www.google.com"; but instead got "nmap -v -p 1-1024 -sS -P0
army.mil
> -T paranoid".
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
