> 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;
$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.


Sandy Keathley
Zend Certified Engineer
Senior Programmer
The Dent Zone Companies, Inc.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to