SQL Parse error

Yii 1.1 General Discussion
1

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

2

My result is like that

3

Try this instead




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

FROM personnel

GROUP BY categorie_id');

/Tommy

4

Thx gay… this is working