CONCAT sql

[ibrahimjan]

Hi All, I got this sql connection to my table wb, it all seems to work fine in phpmyadmin, when testing sql, but when i want to us it, it comes up with: Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING inC:\----------\test3.php on line 75 line 75 is the $query_wb

$query_wb = "SELECT	 CONCAT( "[",		 GROUP_CONCAT(			 CONCAT("{weID:'",`weID`,"'"),			 CONCAT(",weName:'",`weName`,"'}")		 )	 ,"]") AS json FROM wb;";

any Ideas how to make it work??

Edited May 9, 2012 by Ibrahim Home Jan

[justsomeguy]

You need to escape the double quotes that you're using inside the query. Notice how the code is colored, each time you use a double quote inside the query it either starts or ends the query string instead of putting an actual quote in the query.