php - Laravel, using AS does not pass on view side -

i try count(message) number looks nothing wrong in controller side, in view side, getting error :

error rendering view: [home.index]  undefined property: stdclass::$number 

my view side , have code :

foreach($sorgu $value) {     case 'bul1':     $sorgu99[0]+=$value->number;                    break; }  $posts = db::table('xxx');  $posts = db::table('xxx')->select( array('message', db::raw('count(message) number'), db::raw('xxx.time time')));  $posts = db::table('xxx')->join( 'xxs', 'xxx.smscid', '=', 'rcs.smscid', 'inner');  $posts = db::table('xxx')->where('xxs.status','=','1');  $posts = db::table('xxx')->where( 'xxx.time' ,'>', '2012-12-26');  $posts = db::table('xxx')->where(db::raw('length(message)'), '>', '3');  $posts = db::table('xxx')->group_by('message');  $posts = db::table('xxx')->get(); 

each time call db::table() make new query, each line in code above making new query, , in end you're getting posts xxx table. try instead:

$query = db::table('xxx'); $query->select( array('message', db::raw('count(message) number'), db::raw('xxx.time time'))); $query->join( 'xxs', 'xxx.smscid', '=', 'rcs.smscid', 'inner'); $query->where('xxs.status','=','1'); $query->where( 'xxx.time' ,'>', '2012-12-26'); $query->where(db::raw('length(message)'), '>', '3'); $query->group_by('message'); $posts = $query->get(); 

the database queries use method chaining. if want read more method chaining, shawnmccool wrote post it: http://heybigname.com/2012/10/03/php-method-chaining/