SQL Parse error

This Query is working fine inside phpMyadmin

But when using it in yii like that I get a Parse error

Need some help for that

My result is like that

Try this instead

$oCommand = $oDbConnection->createCommand('SELECT concat( \'"\', categorie_id, \'"\', \',\', count( * ) ) AS pc

FROM personnel

GROUP BY categorie_id');


Thx gay… this is working