how to select only one particular field from model in zend framework

Question

How to select only one field from table inside a model. For example: table1(field1, field2 , ..) and the select only field 1

Answer 1

You want only one value or a rowset with one column?

In first case, you can use fetchOne():

$result = $db->fetchOne('SELECT bug_status FROM bugs WHERE bug_id = 2');

Or you can make a select only with the fields you want to retreive:

$select = $db->select() ->from(array('t' => 'table1'), array('field1'));