Thanks for the ideas ...
Ran phpinfo() through the web
magic_quotes_gpc Off Off
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
Then I checked the code to see exactly what I have. Right now there are at least two approaches I'm using, until I find a better solution:
Highlight Mode: (PHP)
$sQuery = 'SELECT `name`,`service_provider_id` AS \'id\' FROM `service_provider` ';
$sQuery.=' ORDER BY `name`';
$this->db->query($sQuery);
while ($rResult = $this->db->fetch_assoc())
$this->db->free_result();
return $aResult;
Highlight Mode: (PHP)
$sCols.='`route`.`name` AS \'name\',REPLACE(`service_provider`.`name`,\'\\\\\',\'\') AS \'service_provider_name\','';
As you can see - the backslashes are in the database ...
Highlight Mode: (MySQL)
mysql
> select service_provider_id
,name
from service_provider
;+---------------------+------------------------------+
| service_provider_id | name |
+---------------------+------------------------------+
| 3 | Amy\'s SP |
| 1 | default |
+---------------------+------------------------------+
2 rows in set (0.00 sec)
I'm stumped, and I'm pretty sure there is a simple solution that I just can't find.