Hello, I ma new to the list and looking for some help with the following query. insert into Temp (CompId) SELECT distinct(company_id) from Associations where product_id=9; When I exe that statement directly on the mysql command line It exe's with no problem. However when I exe that through php $result = mysql_query($query) or die("Query failed : " . mysql_error()); it fails every time. Any Ideas? Using MYSQL 3.23.54 PHP 4.1.2 Thanks Aaron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php