On Saturday, December 16, 2006, Jeffrey wrote; > Have you tried... > echo "<p> $query </p>"; > ...to unsure the variables have the values you expect them to have? --- Another thing to try (particularly with SELECT statements) is to cut and paste the echoed query from your browser to the DBMS prompt (e.g. MySQL prompt or MSSQL Query Analyser), attempt to run it, and then follow up any errors the DBMS reports. HTH, -- Geoff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php