PHP - Better Way Of Sorting Data

Hello.  I have a multi dimensional array that needs to be sorted. Array  top25 [index][product id][number_of_purchases].  The index will contain a unique number for each product id. First product will be 1, second product will be 2, etc.  The product id will be a id number like 34324ac9a89.  The number of purchases will be how many times the item has been purchased. 

- End result:  I want to print the 25 most purchased products in this format.

product id - number of purchases

a39acz   -  503
a8cz9c   - 480
zc8ac   -  392


How do I do this?  Thanks

I have an array like this:

$array[$row] = array (
    'name' = $name,
    'discount' = $discount,
    'price' = $price
);

Now, I have about 200 of those in that array, and im trying to sort by the discount, highest 1st. How would I go about doing that? Thanks.

Just a further question from a earlier post that was complete if i do a search and i want to order them from a drop box the if statement would it just look like
Quote

"select * from Table order by '".$_POST['order']."'"

Or would this not work ?


Thanx

Part of my code:

Code: [Select]
<?php

$arr = array ("Christina", "Daniel", "Andreea);
reset($arr);

foreach ($arr as $username) {

//more code here ...

foreach ($stats as $result) 
{
echo $username."'s points - ".$result."<br />";
}

}

?>

And gives this:
Code: [Select]
Christina's points - 14
Daniel's points - 45
Andreea's points 23

My question is: can you sort the the $result so it will show

Code: [Select]
Daniel's points - 45
Andreea's points 23
Christina's points - 14

Thank you

Ok, So I have a table with customers... But after you add one. The <select> that shows up is unorganized...

Code: [Select]
$con = mysql_connect("localhost","techportal","tech2196");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("innerlink_customers", $con);
$result = mysql_query("SELECT cust_id, customer FROM customerinfo");
while($row = mysql_fetch_assoc($result)){
echo "<option value='" . $row['cust_id'] ."'>" . $row['customer'] . "</option>";
}

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
        )

)

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();

How to sort PHP2d Array using upon key.  eg.
I have a array of
$users[0]['name'] = "abc"
$users[0]['age'] = "12"
$users[0]['sex'] = "M";

$users[1]['name'] = "xyz"
$users[1]['age'] = "15"
$users[1]['sex'] = "M";

$users[2]['name'] = "pqr"
$users[2]['age'] = "16"
$users[2]['sex'] = "F";

Now I have to sort in on age or 'sex',

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=317320.0

I need to sort this:

Code: [Select]
customVar($var1, $var2, $var3);
I have tried:

Code: [Select]
sort(customVar($var1, $var2, $var3));

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 everyone,

Could be possible someone help me on this code please?

I need to group and sort $search_query. They are the keywords extracted from $_SERVER[HTTP_REFERER] (referer in the query).

Thank you in advance.


Code: [Select]
$query = ("SELECT referer, browser_ip, date, customers_id, counter, browser_id, browser_language FROM visitors WHERE SUBSTRING(browser_language,1,1) != '[' ORDER by date DESC");
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {

$referer = $row[0];
IF($referer)
{
    PREG_MATCH("/[\&\?]q=([^&]*)/", $referer, $matches);
        $search_query = RAWURLDECODE($matches[1]);
        $search_query = STR_REPLACE("+", " ", $search_query);
}

........................

Hi - I'm modifying some PHP code that someone else wrote. Below is a snippet of code that basically takes mp3 files files within all the folders in a directory, and creates an RSS feed. In the resulting feed, the files are intermingled in date order.

Instead, I'd like them sorted by the directory that they are in. So, if there are files in these directories:

01-First
02-Second
03-Third

I'd like all the files in the "01-First" directory to come before the "02-Second" directory and so on. Within each directory the files can be sorted as they currently are.  The name of the directory in the code is signified by $dir_name.

I tried sort() and array_multisort() but I couldn't get either of them to work the way I wanted.  Any thoughts?


if ($url_params['mode'] == 'rss2') {

print getRSSHeader('UTF-8', $device, $vm_config, $vm_name, $web_master, $logo_image,$context);
    $mailboxes = array();
if ($dev_dir = @opendir($VMHome . $device)) { //might fail if mailbox has not received first message yet
while ($f = readdir($dev_dir)) {
     if (!eregi("tmp","$f") && !eregi("\.+","$f") && !eregi("Exclude-From-CD", "$f")) { //skip tmp directory and Exclude-From-CD Directories   
     array_push($mailboxes,"$f"); #collect all existing mailboxes
     }
  }
     array_multisort($mailboxes, SORT_DESC);
foreach ($mailboxes as $mailbox) {
$files=array();
$dir_name = $VMHome . $device . '/'. $mailbox .'/'; 
$dir = opendir($dir_name);
while ($f = readdir($dir)) {
  if (eregi("\.txt",$f)){ #if filename matches .txt in the name
     array_push($files,"$f"); #push into $files array
  }
}
foreach($files as $file){
   $props = getProperties($dir_name, $file);
   $uid = getMP3File($dir_name, $file, $props, $device, $mailbox, $vm_config, $vm_name,$context);
   print getRSSItem ($props, $uid, $dir_name, $device, '/' . $mailbox . '/', $context);      
}
}
}
print  '
</channel>
</rss>';
}

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?