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