Update Query
| From: | Aaron Bryer | Date: | Wed, 29 Oct 2003 20:02:00 +0000 |
| Subject: | Update Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31350@lists.php.net to get a copy of this message | ||
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