[PHP-DB] easier way to do this? (time interval)

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

[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)