ORDER BY ?

- 18 Posts
MaDrense Reply #1, 17 years, 1 month ago

Hi,

I’m using xPDO for a new project I’m working on. I’d like to know how I can issue SQL ORDER statements ? Does xPDOCriteria support this or do I have to create an SQL statement ? Could you give me some simple examples of both of these ?

Thanks in advance,

MaDrense
- MODX Staff
- 10,725 Posts
opengeek Reply #2, 17 years, 1 month ago
If you have the latest xPDO from SVN, the new xPDOQuery class provides the sortBy() function for building queries with an ORDER BY clause via the API. Here is an example:
```
<?php
$query= $xpdo->newQuery('MyClass');
$query->sortBy('sort_field', 'ASC');
$myObject= $xpdo->getObject('MyClass', $query);
```
You can of course just write your SQL directly via xPDOCriteria:
```
<?php
$criteria= new xPDOCriteria($xpdo, "SELECT * FROM {$xpdo->getTableName('MyClass')} ORDER BY sort_field ASC");
$myObject= $xpdo->getObject('MyClass', $criteria);
```
Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek