dbx_sort (PHP 4 >= 4.0.6, PHP 5 <= 5.0.4)
dbx_sort --
Sort a result from a dbx_query by a custom sort function
Description bool
dbx_sort ( object result, string user_compare_function )
Returns TRUE FALSE
Note:
It is always better to use ORDER BY
SQL clause instead of dbx_sort() ,
if possible.
Example 1. dbx_sort() example
<?php function user_re_order ( $a , $b ) $rv = dbx_compare ( $a , $b , "parentid" , DBX_CMP_DESC ); $rv ) { $rv = dbx_compare ( $a , $b , "id" , DBX_CMP_NUMBER ); $rv ; $link = dbx_connect ( DBX_ODBC , "" , "db" , "username" , "password" ) "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 ); ?>
See also dbx_compare()
Links
PowWeb $7.77/mo 300GB Diskspace 3000GB Bandwidth Host Unlimited Domains Load Balanced Technology DNS Management PHP4/5 Perl5 CGI SSI MySQL Daily Backup AN Hosting $6.95/mo 250GB Diskspace 2500GB Bandwidth Host 20 Domains PHP RoR Python CGI SSI Unlimited MySQL DB Free Domain for Life 30 Day Money Back 99% Uptime Guarantee Bluefish $6.95/mo 6GB Diskspace 100GB Bandwidth PHP Perl MySQL SSI CGI SSL Free Domain No Setup Fees No Hidden Fees
Hosting Companies
Partners
