Solr Query sort by function (Zend App_Solarium)

Question

I have a table with following fields:

1. created_date
2. published_date
3. sortbyp

I need sort based on another field:

if (sortbyp=1) {
  sort by "published_date" 
}
else {
  sort by "created_date"
}

I need to pass this to a Zend App_Solarium. Like:

$sort = array('mysql_id' => 'desc');

Answer 1

Use SQL order by method: http://www.w3schools.com/sql/sql_orderby.asp

Nothing else to say really.