Searching and Sorting

Hi Jac,

I guess you're using the getRecords function to retrieve your results? If so you can add an orderBy variable to it's array to decide what order the results are displayed in:

  // load records from 'blog'
  list($blogRecords, $blogMetaData) = getRecords(array(
    'tableName'   => 'blog',
    'loadUploads' => true,
    'allowSearch' => true,
    'orderBy'     => "title, content DESC"
  ));

The orderBy variable should contain a MySQL ORDER BY string. You can read about it here: 

http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html

By default the function will order the results by what you have set in the sections settings. (See attached screen shot).

Thanks,

Greg