PHP - Sorting An Array...

i have an array from a database that looks like this (below) but what i want is for the array to be sorted assedningly by the start position

so the team with start position 1 will be 1st and so on...if anyone can help me on what i should do please...thank you

Code: [Select]
Array
(
    [1] => Array
        (
            [team_name] => A Team
            [team_nationality] => British
            [start_position] => 2
        )

    [2] => Array
        (
            [team_name] => B Team
            [team_nationality] => British
            [start_position] => 1
        )
    [3] => Array
        (
            [team_name] => C Team
            [team_nationality] => British
            [start_position] => 4
        )

    [4] => Array
        (
            [team_name] => B Team
            [team_nationality] => British
            [start_position] => 3
        )

)

I am attempting to sort an array by price but cannot seem to get php to do this. Below is the array I am attempting to sort by the value ~ price:

Array
(
    [http://pdt.tradedoubler.com/click?a(1774061)p(19045)prod(550992137)ttid(5)url(http%3A%2F%2Fwww.halfords.com%2Fwebapp%2Fwcs%2Fstores%2Fservlet%2Fproduct_storeId_10001_catalogId_10151_categoryId_165488_productId_561801_langId_-1%3Fsource%3Dtd)] => Array
        (
            [logo] => nc0iicjxmq.gif
            [stock] => In Stock  In Stock
            [price] => 14.99
            [delivery] => 4.99
            [url] => http://pdt.tradedoubler.com/click?a(1774061)p(19045)prod(550992137)ttid(5)url(http%3A%2F%2Fwww.halfords.com%2Fwebapp%2Fwcs%2Fstores%2Fservlet%2Fproduct_storeId_10001_catalogId_10151_categoryId_165488_productId_561801_langId_-1%3Fsource%3Dtd)
            [mname] => Halfords
        )

    [http://pdt.tradedoubler.com/click?a(1774061)p(19045)prod(767538675)ttid(5)url(http%3A%2F%2Fwww.halfords.com%2Fwebapp%2Fwcs%2Fstores%2Fservlet%2Fproduct_storeId_10001_catalogId_10151_categoryId_165497_productId_780417_langId_-1%3Fsource%3Dtd)] => Array
        (
            [logo] => nc0iicjxmq.gif
            [stock] => In Stock  In Stock
            [price] => 19.99
            [delivery] => 4.99
            [url] => http://pdt.tradedoubler.com/click?a(1774061)p(19045)prod(767538675)ttid(5)url(http%3A%2F%2Fwww.halfords.com%2Fwebapp%2Fwcs%2Fstores%2Fservlet%2Fproduct_storeId_10001_catalogId_10151_categoryId_165497_productId_780417_langId_-1%3Fsource%3Dtd)
            [mname] => Halfords
        )

    [http://pdt.tradedoubler.com/click?a(1774061)p(19045)prod(254177017)ttid(5)url(http%3A%2F%2Fwww.halfords.com%2Fwebapp%2Fwcs%2Fstores%2Fservlet%2Fproduct_storeId_10001_catalogId_10151_categoryId_165497_productId_271987_langId_-1%3Fsource%3Dtd)] => Array
        (
            [logo] => nc0iicjxmq.gif
            [stock] => In Stock  In Stock
            [price] => 15.00
            [delivery] => 2.99
            [url] => http://pdt.tradedoubler.com/click?a(1774061)p(19045)prod(254177017)ttid(5)url(http%3A%2F%2Fwww.halfords.com%2Fwebapp%2Fwcs%2Fstores%2Fservlet%2Fproduct_storeId_10001_catalogId_10151_categoryId_165497_productId_271987_langId_-1%3Fsource%3Dtd)
            [mname] => Halfords
        )

    [http://pdt.tradedoubler.com/click?a(1774061)p(19045)prod(550992487)ttid(5)url(http%3A%2F%2Fwww.halfords.com%2Fwebapp%2Fwcs%2Fstores%2Fservlet%2Fproduct_storeId_10001_catalogId_10151_categoryId_165488_productId_561805_langId_-1%3Fsource%3Dtd)] => Array
        (
            [logo] => nc0iicjxmq.gif
            [stock] => In Stock  In Stock
            [price] => 4.99
            [delivery] => 2.99
            [url] => http://pdt.tradedoubler.com/click?a(1774061)p(19045)prod(550992487)ttid(5)url(http%3A%2F%2Fwww.halfords.com%2Fwebapp%2Fwcs%2Fstores%2Fservlet%2Fproduct_storeId_10001_catalogId_10151_categoryId_165488_productId_561805_langId_-1%3Fsource%3Dtd)
            [mname] => Halfords
        )

    [http://pdt.tradedoubler.com/click?a(1774061)p(19045)prod(18823539)ttid(5)url(http%3A%2F%2Fwww.halfords.com%2Fwebapp%2Fwcs%2Fstores%2Fservlet%2Fproduct_storeId_10001_catalogId_10151_categoryId_165488_productId_155878_langId_-1%3Fsource%3Dtd)] => Array
        (
            [logo] => nc0iicjxmq.gif
            [stock] => In Stock  In Stock
            [price] => 18.00
            [delivery] => 4.99
            [url] => http://pdt.tradedoubler.com/click?a(1774061)p(19045)prod(18823539)ttid(5)url(http%3A%2F%2Fwww.halfords.com%2Fwebapp%2Fwcs%2Fstores%2Fservlet%2Fproduct_storeId_10001_catalogId_10151_categoryId_165488_productId_155878_langId_-1%3Fsource%3Dtd)
            [mname] => Halfords
        )

    [http://pdt.tradedoubler.com/click?a(1774061)p(19045)prod(580777789)ttid(5)url(http%3A%2F%2Fwww.halfords.com%2Fwebapp%2Fwcs%2Fstores%2Fservlet%2Fproduct_storeId_10001_catalogId_10151_categoryId_242553_productId_385055_langId_-1%3Fsource%3Dtd)] => Array
        (
            [logo] => nc0iicjxmq.gif
            [stock] => In Stock  In Stock
            [price] => 21.99
            [delivery] => Free Shipping
            [url] => http://pdt.tradedoubler.com/click?a(1774061)p(19045)prod(580777789)ttid(5)url(http%3A%2F%2Fwww.halfords.com%2Fwebapp%2Fwcs%2Fstores%2Fservlet%2Fproduct_storeId_10001_catalogId_10151_categoryId_242553_productId_385055_langId_-1%3Fsource%3Dtd)
            [mname] => Halfords
        )

    [http://pdt.tradedoubler.com/click?a(1774061)p(19045)prod(18823503)ttid(5)url(http%3A%2F%2Fwww.halfords.com%2Fwebapp%2Fwcs%2Fstores%2Fservlet%2Fproduct_storeId_10001_catalogId_10151_categoryId_165497_productId_217063_langId_-1%3Fsource%3Dtd)] => Array
        (
            [logo] => nc0iicjxmq.gif
            [stock] => In Stock  In Stock
            [price] => 24.99
            [delivery] => Reserve and Collect
            [url] => http://pdt.tradedoubler.com/click?a(1774061)p(19045)prod(18823503)ttid(5)url(http%3A%2F%2Fwww.halfords.com%2Fwebapp%2Fwcs%2Fstores%2Fservlet%2Fproduct_storeId_10001_catalogId_10151_categoryId_165497_productId_217063_langId_-1%3Fsource%3Dtd)
            [mname] => Halfords
        )

    [http://track.webgains.com/click.html?wgcampaignid=72782&wgprogramid=2730&product=1&wglinkid=90005&productname=Continental+Sport+Contact+Road%2FHybrid+Bicycle+Tyre&wgtarget=http://www.awcycles.co.uk/brands/Continental/Sport_Contact_Road/Hybrid_Bicycle_Tyre] => Array
        (
            [logo] => 8yfd588e8t.jpg
            [stock] => In Stock  In Stock
            [price] => 21.99
            [delivery] =>
            [url] => http://track.webgains.com/click.html?wgcampaignid=72782&wgprogramid=2730&product=1&wglinkid=90005&productname=Continental+Sport+Contact+Road%2FHybrid+Bicycle+Tyre&wgtarget=http://www.awcycles.co.uk/brands/Continental/Sport_Contact_Road/Hybrid_Bicycle_Tyre
            [mname] => AW Cycles
        )

)

Any help would be much appreciated.

Thanks
Simon

Hello, i need some help with sorting arrays by it's value. lets say i want to have two different html tables listing the employees and another for the managers, then i want to sort them by Group ID's:

Etc: Workers as the key / 1 as the value.

Groups:
Workers => 1
Managers => 2

Workers Group ID John 1 Peter 1 Lance 1
Managers Group ID Carol 2 Greg 2 Brian 2
How can i do this?

Hi does anyone know how to sort the array below (files)
   echo "<br /><br /><b>Favorites</b><br />";
   $d = dir("/mnt/disk/v1/mfiles/downloads/music/favorites/");
      while (false !== ($entry = $d->read()))
         {
            if($entry!='.' && $entry!='..')
               {
                  if(is_dir($entry))
                     {
                        echo 'true';
                        $subdirs = get_leaf_dirs($entry);
                        if ($subdirs)
                           $array = asort(array_merge($array, $subdirs));
                        else
                           $array[] = $entry;
                     }
                     echo '<a href="/scripts/download.php?actie=favorites/'.$entry.'" title="Click here to download this song" target="_blank">'.left($entry,(strlen($entry)-4)).'</a><br />';
               }
         }
         $d->close();

Hello.  I am just trying to sort an array alphabetically.  Here's the code I'm using:


function GetAssocCharities($registrationNo)
{
$db = ConnectionString::ConnectTo_www_ago_mo_gov_data();
$sqlstring = "SELECT * FROM charityPartners where RegistrationNo LIKE '$registrationNo' ORDER BY Name";


$results = @mysql_query($sqlstring);

$org = null;


while ($resultArray = mysql_fetch_array($results))
{

$temp = new Registrants($resultArray['ARegNoFormatted'], $resultArray);

$org[] = $temp; 
}

return asort($org);

}


When I try to loop through the array using a foreach loop, I get an error that Invalid argument supplied for foreach().

Here's my foreach loop:

$lstCharities = OrgQueries::GetAssocCharities($registrant->RegNoFormatted);

foreach($lstCharities as $c)
{

//dom something here
}



I'm sure its something with not understanding list v array or something or that nature, but I'm not having much luck figuring it out with google.

Thanks!

I have an array that has data in it and its being sorted like this:

Code: [Select]
Source 1 (zip): filename.zip
Source 1 (jpg): filename.jpg
Source 1 (png): filename.png
Source 2 (zip): filename.zip
Source 2 (jpg): filename.jpg
Source 2 (png): filename.png
Source 3 (zip): filename.zip
Source 3 (jpg): filename.jpg
Source 3 (png): filename.png

Id like the data to be sorted like this instead, but i dont know how to get it to sort this way:

Code: [Select]
Source 1 (zip): filename.zip
Source 2 (zip): filename.zip
Source 3 (zip): filename.zip
Source 1 (jpg): filename.jpg
Source 2 (jpg): filename.jpg
Source 3 (jpg): filename.jpg
Source 1 (png): filename.png
Source 2 (png): filename.png
Source 3 (png): filename.png

Here's my code: any help is appreciated. thanks.

for ($i = 1; $i <= 5; $i++) {
$src[$i] = 'Source '.$i.' ('.$ext.'): '.$filename.'';
array_multisort($src, SORT_ASC, SORT_STRING);
}

I have an array of type
Code: [Select]
Array ( [2] => Array ( [name] => Shelby Baptist Medical Ctr [city] => Alabaster ) [1] => Array ( [name] => Andalusia Regional Hospital [city] => Andalusia ) [0] => Array ( [name] => Long Term Hospital of Anniston [city] => Anniston ))
How can sort the keys of an array but there content remains the same so that they are like
Code: [Select]
Array ( [0] => Array ( [name] => Shelby Baptist Medical Ctr [city] => Alabaster ) [1] => Array ( [name] => Andalusia Regional Hospital [city] => Andalusia ) [2] => Array ( [name] => Long Term Hospital of Anniston [city] => Anniston ))
Can someone please point me if there is any func. for this

Hi All

I'm new to php and I have a multidimensional array set up which I need to sort for a results list from an assessment.

The array is $gradout['name']['userid']=score.

I need to sort the array by score in a decending order. 

['name'] is a string and ['userid'] is a numeric.

I've tried looking at the php manual but It's just confusing me.  Can anyone explain to me in laymans terms what I need to do and why.

Hi,

I have got some data out of my database, I would now like to sort all of this by putting the data into arrays, something looking like this:

branch - costs - profit

France - 406.85 - 1392.48

So each branch is one item in the array, but has the costs and profit with it too.

I would then like to sort those arrays by things like branch name, costs and profit.

Is this possible?

I want to create an array based on data in a multidimensional array. Take, for example:

$table[1] = array('husband' => array ('firstname'=> 'Albert',
                                                           'lastname' => 'Einstein',
                                                           'age'      => 129),
                           'wife'         => array ('firstname' => 'Mileva',
                                                           'lastname'  => 'Einstein',
                                                           'age'       => 128));

What would be the best approach, when you want to
create an array with only the last names or the ages? Are there some
things like wildcards in the PHP array universe to skip the first array level?

Any suggestion is very appreciated. I tried several strategies, but ended up creating the same mulitdimensional array as above.

Hey guys, quick question.

I have an array that looks like (blow). How can i sort it based on array[0][3], the #'s 1,2,3,4,5,6 are what i want to sort by in ASC order.

Code: [Select]
<?php

Array ( 
[0] => Array ( 
[1] => Link Name 
[2] => URL
[3] => 1 
[4] => fy 
) 
[1] => Array ( 
[1] => Link Name 
[2] => URL
[3] => 2 
[4] => fy 
) 
[2] => Array ( 
[1] => Link Name 
[2] => URL
[3] => 3 
[4] => fy 
) 
[3] => Array ( 
[1] => Link Name 
[2] => URL
[3] => 4 
[4] => fy 
) 
[4] => Array ( 
[1] => Link Name 
[2] => URL
[3] => 5 
[4] => fy 
) 
[5] => Array ( 
[1] => Link Name 
[2] => URL
[3] => 6 
[4] => fy 
)

?>

Thanks for the help.

I have an array and when i do a print_r(), i get this:

Array ( => Array ( [path] => 1 [order] => 2 ) [1] => Array ( [path] => 2 [order] => 2 ) [2] => Array ( [path] => 3 [order] => 1 ) )

I want to sort it so that the array with an order of 1 is at the front, i.e. that last array in this case. I tried asort but that didnt do anything...

Hi.
I have a multidimensional array and i need sort it by two different key.
I've tried almost every sort function but no chance.

Code: [Select]
Array (
[0] => Array (
[0] => 1 [id] => 1
[11] => this is test [main_txt] => this is test
[12] => 943965420 [add_time] => 943965420
[13] => 1323356400 [add_date] => 1323356400 )
[1] => Array (
[0] => 3 [id] => 3
[11] => another test [main_txt] => another test
[12] => 943965120 [add_time] => 943965120
[13] => 1323702000 [add_date] => 1323702000 )
[2] => Array (
[0] => 32 [id] => 32
[11] => oppss one more test [main_txt] => oppss one more test
[12] => 943944900 [add_time] => 943944900
[13] => 1323702000 [add_date] => 1323702000 )
[3] => Array (
[0] => 5 [id] => 5
[11] => okay, this is last one. Seriously [main_txt] => okay, this is last one. Seriously
[12] => 943937160 [add_time] => 943937160
[13] => 1323615600 [add_date] => 1323615600 )
)
I need sort by add_date(Newer to Older) first then add_time(Later to Earlier) later.

I hope i made my self clear.

I can't quite figure out how to sort this array the way I want.  I have tried "array_multisort" but can only get one demension to sort.

Here is the array...

$catagory = array(   
   array('Catagory 1', 8,
      array('Sub Catagory 1 Item 1', 8),
      array('Sub Catagory 1 Item 2', 9),
      array('Sub Catagory 1 Item 3', 7),
      array('Sub Catagory 1 Item 4', 6),
      ),

   array('Catagory 2', 10,
      array('Sub Catagory 2 Item 1', 6),
      array('Sub Catagory 2 Item 2', 5),
      array('Sub Catagory 2 Item 3', 9),
      array('Sub Catagory 2 Item 4', 10),
      ),
     );

I would like the top catagories sorted in desending order and all the subcatagories sorted in desending order.  The result would sort like this...

Catagory 2  = 10
    Sub Catagory 2 Item 4 = 10
    Sub Catagory 2 Item 3 = 9
    Sub Catagory 2 Item 1 = 6
    Sub Catagory 2 Item 2 = 5
Catagory 1 = 8
    Sub Catagory 1 Item 2 = 9
    Sub Catagory 1 Item 1 = 8
    Sub Catagory 1 Item 3 = 7
    Sub Catagory 1 Item 4 = 6

How can I achieve this.  Thanks for any help.

So i've got a CSV file, pull data from it and it's stored within an array. $data[0] contains date that looks like so 9/14/2011 00:00:00. How can i sort this array before displaying it so that it's sorted by Date ASC by default.

Code: [Select]
<?php
if (($handle = fopen("http://www.website.com/images/uploads/Recruitment_for_Web.csv", "r")) !== FALSE) 
{
while (($data = fgetcsv($handle, 10000, ",")) !== FALSE) 
{
echo '<tr>';
echo '<td>' . str_replace("0:00:00","",$data[0]) . '</td>';
echo '<td>' . $data[1] . '</td>';
echo '<td>' . $data[2] . '</td>';
echo '<td>' . $data[3] . '</td>';
echo '<td>' . $data[4] . '</td>';
echo '<td>'; 
if($data[7] != "")
{
echo '<a href="' . $data[7] . '" target="_blank">' . $data[5] . '</a>';
}
else
{
echo $data[5];
}
echo '</td>';
echo '<td>' . $data[6] . '</td>';
echo '</tr>';
   
}
fclose($handle);
}
?>
Thanks