Zend DB Select : ORDER BY FIELD('id',some_array) - how?

mysql zend-framework zend-db
srgb picture srgb · Jul 7, 2011 · Viewed 11k times · Source

How would you write the following query in Zend framework?

SELECT * FROM table_name ORDER BY FIELD(field_name, 'Small','Medium','Large');

I just need the "Order by" part :)

Thanks!

Answer

Marcin picture Marcin · Jul 7, 2011

What about this:

      $db = Zend_Db_Table::getDefaultAdapter();

      $select = $db->select();

      $select->from('table_name')
              ->order(new Zend_Db_Expr("FIELD(field_name, 'Small','Medium','Large')"));


      var_dump($select->assemble());

Results in:

string 'SELECT `table_name`.* FROM `table_name` ORDER BY FIELD(field_name, 'Small','Medium','Large')' (length=92)

Related questions

How to print exact sql query in zend framework ?

I have the following piece of code which i taken from model, ... $select = $this->_db->select() ->from($this->_name) ->where('shipping=?',$type) ->where('customer_id=?',$userid); echo $select; exit; // …

Read More
'PDOException' with message 'SQLSTATE[HY000] [2002] zend framework

Any one plz tell me why i am getting this error ?? firstly my internet connection was good today its not good so i am getting this error.how can i fix this any idea plz?? Fatal error: Uncaught exception 'PDOException' …

Read More
How update a database table record in Zend?

I am using select like this and it is fetching record successfully: $table = new Bugs(); $select = $table->select(); $select->where('bug_status = ?', 'NEW'); $rows = $table->fetchAll($select); But Now I want to update same record. For …

Read More