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

2009-01-26 Thread Dave.McGovern
snip 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

[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,