PHP Manual . ... PHP 4 >= 4.0.6) dbx_sort -- Sort a result from a dbx_query by a custom sort function . ... This function is EXPERIMENTAL . ... php function user_re_order ($a, $b) { $rv = dbx_compare ($a, $b, parentid , DBX_CMP_DESC); if (!$rv) $rv = dbx_compare ($a, $b, id ); return $rv; } $ link = dbx_connect ( odbc , , db , username , password ) or die ( Could not connect ); $ result = dbx_query ($ link , SELECT id, parentid , description FROM tbl ORDER BY id ); ...