Re: Could not run query

> I need help to track down the cause of the error,"Could not run query" > > A typical query is > > $laterrecords = mysql_query("SELECT * FROM messages WHERE > logged > > $timebegin ORDER BY logged DESC" ) or die ("Cannot > select:<br>$query<br>Error: " . mysql_error()); Try putting single quotes around $timebegin. If $timebegin is not a Unix timestamp, you can also use the DATE functions in MySQL, A good way to debug these problems is to always put the query in a separate variable $query = "SELECT * FROM messages ..." //echo $query; //exit; $laterrecords = mysql_query($query); Then echo the actual interpolated query to the screen, copy it, and run it manually in a query tool (phpMyAdmin, MySQLQueryBrowser, or similar). The query tool will tell you where the error is. SK -- Sandy Keathley Zend Certified Engineer Senior Programmer The Dent Zone Companies, Inc. 214-393-2228