something i cannot figure out by myself
I collect several items from other pages into an extra bakery page,
I made a new field called 'brand'
i added a piece of code
// Query items (for this page)
$query_items = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_bakery_items WHERE brand = '".$soortselectie."' AND active = '1' AND title != '' ORDER BY title DESC");
$num_items = $query_items->numRows();
the order of the items is not alphabetic but alphabetic-per-(items per page) ..
a, b, c and d from page 1,
a1, b1 and c1 from page 2
a2, b2, c2 from page three
all have the extra field "mybrand"
result in the "mybrand" page is:
it has to be
anyone knows what I am missing here?