Populate select element

Question

I want to populate a <select> element using the results from my categories table. In order to do that I use the following code.

$catlist = Categories::where('type','=',$content_type)
           ->get(array('id','name'))->toArray(); 

The result structure is an array of rows.

array
  0 => 
   array
      'id' => int 1
      'name' => string 'article' 
  1 => 
   array
     'id' => int 2
     'name' => string 'news' 

A foreach statement surely would solve my problem but I'm looking for a better solution.

Answer 1

You could use the lists(string $column [, string $key ]) method for this, found under "Retrieving A List Of Column Values" in the documentation...

$catlist = Category::where('type', $content_type)->lists('name');