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:[EMAIL PROTECTED]
> Sent: Wednesday, October 29, 2003 3:02 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Update Query
> Hello, I ma new to the list and looking for some help with
> the following
> insert into Temp (CompId) SELECT distinct(company_id) from
> 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
> 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