Order by?

[Hall of Famer]

Well just pass ORDER BY to the whereclause, if you have a whereclause. Incase you do not have a whereclause(and thus selecting all rows), you can do the following:

PHP Code:

$stmt = $GLOBALS['adopts']->select("items", array(), "1 ordered by itemname"); 


It may look a bit funny, but the magical keyword '1' does the trick for ya.