RE: [PHP-DB] Update Query
| From: | Hutchins, Richard | Date: | Wed, 29 Oct 2003 20:07:23 +0000 |
| Subject: | RE: [PHP-DB] Update Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31351@lists.php.net to get a copy of this message | ||
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
>
>