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