queryScalar() problem

Yii 1.1 General Discussion
1

I’ve this working:




public function svcCharge() {

	return Yii::app()->db->createCommand('SELECT charge FROM tbl_svc_charge WHERE description = "levy"')->queryScalar();

}

but problem with this:




public $levy=Yii::app()->db->createCommand('SELECT charge FROM tbl_svc_charge WHERE description = "levy"')->queryScalar();

Error log from apache:




[Sat Oct 09 17:25:34 2010] [error] [client 127.0.0.1] PHP Parse error:  syntax error, unexpected '(', expecting ',' or ';' in /var/www/stock/protected/controllers/TransactionController.php on line 8, referer: http://localhost/stock/index.php?r=transaction/admin

Thanks!

2

It’s a problem of your php code. You can’t do such assignment when defining a class variable. Even “public $foo = 2+3;” won’t work. Do it like in your first code snippet.

3

Many thanks!