xPDOQuery.groupby

Mark Hamstra

Ivan Bochkarev

Last updated Apr 6th, 2019 | Page history | Improve this page | Report an issue

xPDOQuery::groupby¶

Add a GROUP BY clause to the query.

Syntax¶

API Docs: xPDOQuery::groupby()

xPDOQuery groupby (string $column, [string $direction = ''])

Example¶

Grab the different 'type's of Boxes with at least one Box of width 15.

$query = $xpdo->newQuery('Box');
$query->where(array(
   'width' => 15,
));
$query->groupby('type');
$boxes = $xpdo->getCollection('Box',$query);

See Also¶

xPDOQuery