?php function user_re_order ($a, $b) {$rv = dbx_compare ($a, $b, "parentid", DBX_CMP_DESC); if (!$rv) {$rv = dbx_compare ($a, $b, "id", DBX_CMP_NUMBER);} return $rv;} $link = dbx_connect (DBX_ODBC, "", "db", "username", "password") or die ("Could not connect"); $result = dbx_query ($link, "SELECT id, parentid, description FROM tbl ORDER BY id"); / / data in $result is now ordered by id dbx_sort ($result, "user_re_order"); / / data in $result is now ordered by parentid (descending), then by id dbx_close ($link);?
?php function user_re_order ($a, $b) {$rv = dbx_cmp_desc($a, $b, "parentid"); if (!$rv) $rv = dbx_cmp_asc($a, $b, "id"); return $rv;} $link = dbx_connect("odbc", "", "base de données", "utilisateur", "mot de passe") or die ("Impossible de se connecter"); $result = dbx_query($link, "SELECT id, parentid, description FROM tbl ORDER BY id"); echo "Les données sont maintenant triées par id br "; dbx_sort($result, "user_re_order"); echo "Les données sont maintenant triées par parentid décroissant, puis par id br"; dbx_close($link);?