RE: [PHP-DB] query fails with mysql_query but success with direct SQL from command line

2002-09-26 Thread John W. Holmes
How do you know if fails? What does mysql_error() say? ---John Holmes... > -Original Message- > From: Thoenen, Peter Mr. EPS > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 26, 2002 10:13 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] query fails with mysql

[PHP-DB] query fails with mysql_query but success with direct SQL from command line

2002-09-26 Thread Thoenen, Peter Mr. EPS
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)