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

Reply via email to