| 06 May 2011
This function can sort a query result in some way. Maximum of 2000 rows in live and more if you cache the order.
For exemple, for album, you can have the style information like rock, pop, metal, etc... But you can also have informations like 'is a best seller', 'is new', 'is a legendary album', etc...
If you want to mix everything like a rock album which is a best seller first, and pop album which is new, etc... Every display to be different than the previous one, you can use this function. It alternate the album by two fields.
You can use that function to push up the products that you want to display first. For exemple, I want that my first products are the one who are in stock, new and best seller in an alternative way, but too, with a different manufacturer.
Array
(
[4] => stdClass Object
(
[id] => 4
[style] => metal
[type] => best seller
[dummy_field] => dummy value
)
[11] => stdClass Object
(
[id] => 11
[style] => pop
[type] => legend
[dummy_field] => dummy value
)
[18] => stdClass Object
(
[id] => 18
[style] => rock
[type] => new
[dummy_field] => dummy value
)
[7] => stdClass Object
(
[id] => 7
[style] => metal
[type] => best seller
[dummy_field] => dummy value
)
[14] => stdClass Object
(
[id] => 14
[style] => pop
[type] => legend
[dummy_field] => dummy value
)
[21] => stdClass Object
(
[id] => 21
[style] => rock
[type] => new
[dummy_field] => dummy value
)
[10] => stdClass Object
(
[id] => 10
[style] => pop
[type] => best seller
[dummy_field] => dummy value
)
[17] => stdClass Object
(
[id] => 17
[style] => rock
[type] => legend
[dummy_field] => dummy value
)
[6] => stdClass Object
(
[id] => 6
[style] => metal
[type] => new
[dummy_field] => dummy value
)
[13] => stdClass Object
(
[id] => 13
[style] => pop
[type] => best seller
[dummy_field] => dummy value
)
[20] => stdClass Object
(
[id] => 20
[style] => rock
[type] => legend
[dummy_field] => dummy value
)
[9] => stdClass Object
(
[id] => 9
[style] => metal
[type] => new
[dummy_field] => dummy value
)
[16] => stdClass Object
(
[id] => 16
[style] => rock
[type] => best seller
[dummy_field] => dummy value
)
[5] => stdClass Object
(
[id] => 5
[style] => metal
[type] => legend
[dummy_field] => dummy value
)
[12] => stdClass Object
(
[id] => 12
[style] => pop
[type] => new
[dummy_field] => dummy value
)
[19] => stdClass Object
(
[id] => 19
[style] => rock
[type] => best seller
[dummy_field] => dummy value
)
[8] => stdClass Object
(
[id] => 8
[style] => metal
[type] => legend
[dummy_field] => dummy value
)
[15] => stdClass Object
(
[id] => 15
[style] => pop
[type] => new
[dummy_field] => dummy value
)
)


