ST3 SQL color with quotes

[proper]

Hi,

I have a slight color problem when I cut my sql string.
A picture is better than words :

The first line is OK.
But if I cut my sql query I lose the colors.
Is there a way to keep the colors of the first line in the second?

Thanks.

[jfcherng]

SQL injection alert

[kingkeith]

this would require some potentially complicated changes to the syntax definition

Issue: [PHP] SQL Syntax highlighting breaks at first appearance of matching quote

[sdclee]

You have nested single quotes in the second line, so a simple change to:
$sql = "select … ";
would retain the correct syntax highlighting.

[proper]

Thank you all.
Yes using a double quote will be correct in my example, but the real issue comes from using define as in Kingkeith’s example :

$query_2 = “SELECT * FROM “.DATABASE_MAIN.”.dbo.test WHERE 1=1;”;