[TxMt] SQL queries in PHP could broke code view

Fabio fauzzo at email.it
Tue Oct 13 16:14:31 UTC 2009


Hi,

try to insert a query like this below in your php code and see what  
happens with TM colours: they will be "broken" after the query.
The problem seems related to the fact that the query has been broken  
into more than one line and there are filtered chars like \' or  
closing ")" not related to the logic sequence.

Is there any fix to see things well in these situations?

thanks

$var = "SELECT  
field_1 
,REPLACE 
(REPLACE(REPLACE(REPLACE(LOWER(field_2),'\'',''),'/',''),' (the)',  
''),'.', '') AS test,
									 
SOUNDEX 
(REPLACE 
(REPLACE 
(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LOWER(field_2),' (the)',  
''),'-',''),'+',''),'(',''),')',''),'/',''),'.','')) as test2
									FROM table ORDER BY field_2";

--
Ciao

Fabio



 
 
 --
 Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f
 
 Sponsor:
 Forza Motosport3: spingi più di 400 auto straordinarie al limite delle loro possibilità su oltre 100 circuiti tra i più entusiasmanti al mondo!
 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=9728&d=13-10



More information about the textmate mailing list