title: How to put sql query in an array in yii
body: <p>I have a line like this:</p>
  
  <pre><code> $line= Yii::app()-&gt;db-&gt;createCommand()-&gt;select('line_no')-&gt;from('tblvehicleimage') -&gt;where('serial_no=:serial_no', array(':serial_no'=&gt;$model-&gt;serial_no)) -&gt;queryScalar();
  </code></pre>
  
  <p>how to put all the $line data in an array? Is there any way i can use 'mysql_fetch_array'?</p>