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
? What is the mysql_error() returning to you?
I'd also recommend you echo out the query to the browser window before
sending it so you can see exactly what's being sent to the database. That'll
help you troubleshoot SQL problems on your own.
-Original Message-
From: Aaron Bryer [mailto:[EMAIL