RE: [PHP-DB] MySQL query executes outside of PHP, but not in PHP

2009-01-26 Thread Dave.McGovern
> error_log("Hey, the SQL is: $sql"); > > Then look in your php error log (you do have error logging enabled, > right?) [McGovern, Dave] Enabled, yes. Usefully enabled, no (correcting this helped a lot). > > If that SQL in the error log is fine, then your problem is > $client2->multi_query

[PHP-DB] MySQL query executes outside of PHP, but not in PHP

2009-01-23 Thread Dave.McGovern
Hi, I am running: PHP 5.2.8, Apache 2.2.11, MySQL 5.1.30 on Win32/XP. I have a number of queries on my page which are very similar in structure, and they all work except for the following one. $mysql['process'] = $client2->real_escape_string($clean['process']); $sql = "SELECT f.name, f.descript