RE: [PHP-DB] Update Query

I did that below is the exact excerpt from the source of the web browser <!--insert into Temp (CompId) SELECT distinct(company_id) from Associations where product_id=10--> The My Sql Error is Query failed : You have an error in your SQL syntax near '' at line 1 I have tried entering () around the select statement but that seamed to make more errors Thanks Aaron -----Original Message----- From: Hutchins, Richard [mailto:Richard.Hutchins@Getingeusa.com] Sent: Wednesday, October 29, 2003 3:07 PM To: 'aaron@web-sites.com'; php-db@lists.php.net Subject: RE: [PHP-DB] Update Query How do you know it failed? 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:aaron@web-sites.com] > Sent: Wednesday, October 29, 2003 3:02 PM > To: php-db@lists.php.net > Subject: [PHP-DB] Update Query > > > > 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php