On Nov 15, 2008, at 1:00 PM, running.cz@gmail.com wrote:

Date: Fri, 14 Nov 2008 16:35:13 -0800 (PST) From: kaja running.cz@gmail.com Subject: [TxMt] PHP MySQL highlighting To: textmate@lists.macromates.com Message-ID: 20510850.post@talk.nabble.com Content-Type: text/plain; charset=us-ascii

another bug/issue I have with textmate - mysql highlighing in php code works only sort of. If I write:

"SELECT * FROM `table` WHERE `column` = 'value';";

it's fine - FROM and WHERE are blue, the rest is green.. but if I write something like

"SELECT * FROM `".$table."` WHERE `".$column."` = '".$value."';";

the MySQL highlighting stops working at FROM.

Hi Kaja,

the keyword matching can't guess that you concatenate strings. You are already using double quotes for the string, so why not embed your variables anyway?

"SELECT * FROM `{$table}` WHERE `{$column}` = '{$value}';";

This would highlight correctly since it is a continuous string.

Regards, Torsten --

Torsten Walter __________________________________________________ 3d-M | Professional Solutions for Online and Offline Media Zum Piepenkerl 2 | 49090 Osnabrück | Germany __________________________________________________ website: http://legacy.3d-m.de blog: http://playground.magicrising.de/ __________________________________________________ phone: +49 541 69 16 645 mobile: +49 179 12 13 561 __________________________________________________ email: tw@3d-m.de