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
