[TxMt] Re: PHP MySQL highlightin

[Torsten Walter]

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

> Date: Fri, 14 Nov 2008 16:35:13 -0800 (PST)
> From: kaja <running.cz at gmail.com>
> Subject: [TxMt]  PHP MySQL highlighting
> To: textmate at lists.macromates.com
> Message-ID: <20510850.post at 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 at 3d-m.de