Multiple Where Statements

Question

I have the following line of code

$select =  $read->select()
            ->from($batchTable,array('id','batch','strength','flavor','brand'))
            ->where('status', 1)
            ->order('created DESC') ;

How do I do multiple where statements?

Answer 1

$select =  $read->select()
            ->from($batchTable,array('id','batch','strength','flavor','brand'))
            ->where('status', 1)
            ->where('other_field', 'some_value')
            ->where('an_other_one' <> ?', 8)
            ->order('created DESC');