Need Help on Sorting Arrays..

Thanks a lot heilo... I'll try this one out. ------------------------------------------------- hm...... Seems as if it was really impossible to make this with the query. (Unless one would change the dbmodel so that the connections get easier) Well to solve your array-problem use array_multisort:

   $supplier = array(    'FTSL1'
                   ,    'FTSL1'
                   ,    'FTSL2'
                   ,    'FTSL2'
                   ,    'FTSL2'
                   ,    'MIC'
                   ,    'MIC'
                   ,    'MIC'
                   ,    'MIC'
                   ,    'MIC'
                   ,    'MIC'
                   );
   $partCode = array(    '954334-02310730'
                   ,    '9445R0-05200730'
                   ,    '324941-06100900'
                   ,    '324941-06200900'
                   ,    '324941-0570A900'
                   ,    '981028-03570730'
                   ,    '811600-41650730'
                   ,    '811600-41050730'
                   ,    '811600-31700740'
                   ,    '954105-03050730'
                   ,    '934100-03650730'
                   );
   $partName = array(    'Ceramic Condenser'
                   ,    'Ceramic Condenser'
                   ,    'Chemical Condenser'
                   ,    'Chemical Condenser'
                   ,    'Ceramic Condenser'
                   ,    'Connector'
                   ,    'IC'
                   ,    'IC'
                   ,    'IC'
                   ,    'Ceramic Condesner'
                   ,    'Capacitor'
                   );
   $partQty = array(    0
                   ,    0
                   ,    100
                   ,    0
                   ,    300
                   ,    3000
                   ,    2000
                   ,    19000
                   ,    2500
                   ,    12000
                   ,    2000
                   );
   $soQty = array(    7890
               ,    10800
               ,    3300
               ,    4700
               ,    500
               ,    3000
               ,    654
               ,    18162
               ,    654
               ,    11166
               ,    546
               );

   $numbers = array(    '2nd'
                   ,    '1st'
                   ,    '4th'
                   ,    '5th'
                   ,    '3rd'
                   ,    '8th'
                   ,    '11th'
                   ,    '10th'
                   ,    '9th'
                   ,    '7th'
                   ,    '6th'
                   );

   $ar = array(     'supplier'    =>    $supplier
               ,    'partName'    =>    $partName
               ,    'partCode'    =>    $partCode
               ,    'partQty'     =>    $partQty
               ,    'soQty'       =>    $soQty
               ,    'numbers'     =>    $numbers
               );

// echo the 2d-array $cMax = count($ar['supplier']); for($c = 0; $c < $cMax; $c++)

       echo    $ar['supplier'][$c].' | '.
               $ar['partName'][$c].' | '.
               $ar['partCode'][$c].' | '.
               $ar['partQty'][$c].' | '.
               $ar['soQty'][$c].' | '.
               $ar['numbers'][$c].
               '<br>'."\n";

// sort it array_multisort($ar['supplier'], SORT_ASC, SORT_STRING

               ,    $ar['partName'], SORT_ASC, SORT_STRING
               ,    $ar['partCode'], SORT_ASC, SORT_STRING
               ,    $ar['partQty']
               ,    $ar['soQty']
               ,    $ar['numbers']
               );

echo '<br><br>'; // echo the 2d-array $cMax = count($ar['supplier']); for($c = 0; $c < $cMax; $c++)

       echo    $ar['supplier'][$c].' | '.
               $ar['partName'][$c].' | '.
               $ar['partCode'][$c].' | '.
               $ar['partQty'][$c].' | '.
               $ar['soQty'][$c].' | '.
               $ar['numbers'][$c].
               '<br>'."\n";

hope this works, and helps?! .ma ------------------------------------------ Marie Gezeala M. Bacuño II Information Systems Department Your choice: the red pill or the blue pill. _________________________________________________________________ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail