[PHP-DB] 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 -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-DB] query fails with mysql_query but success with direct SQL from command line
Hello everybody,
This command fails when ran with mysql_query but succeeds when ran command
line. Have verified connection good... a simple mysql_query(SELECT * FROM
{$user}_tickets); returns true. Any ideas?
$query=mysql_query(
SELECT *, UNIX_TIMESTAMP(date_submitted) AS n,
UNIX_TIMESTAMP(date_updated) AS out FROM {$user}_tickets
WHERE (
((UNIX_TIMESTAMP(date_submitted)-0)259200 AND
issue='LSR' AND date_updated IS NULL) OR
((UNIX_TIMESTAMP(date_submitted)-UNIX_TIMESTAMP(date_updated))259200 AND
issue='LSR' AND date_updated IS NOT NULL)
) OR (
((UNIX_TIMESTAMP(date_submitted)-0)86400 AND
issue='LSR' AND date_updated IS NULL) OR
((UNIX_TIMESTAMP(date_submitted)-UNIX_TIMESTAMP(date_updated))86400 AND
issue='LSR' and date_updated IS NOT NULL)
);
);
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
