PHP - Menu Sorting.

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

Happy New Year from a Newbie.   I have data in a MySql database table (let's call it data_table) which is input by users via a form. Their input consists of one or a list of items seperated by spaces. This ends up in one column (let's call it data_col) as in the following example format:   id      data_col 1       cat 2       elephant giraffe 3       dog rabbit 4       snake cat bird 5       fish dog ..       etc.   I need help with a PHP script to read only this column into a string variable with which I can then (a) use explode to seperate it into an array containing the seperated words and removing the spaces, if any, at the same time and (b) use array_unique to remove any duplicated words in the array, before finally displaying the array as an A-Z ordered list as below.   bird cat (duplicate removed) dog (duplicate removed) elephant fish giraffe rabbit snake   Many thanks for any help offered.

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

I am looking for information on how to accomplish this:

I want to order an array based on a variable. I have an array that is set like this array(1,2,3,4,5,6).
I want to order this array base on a variable that will be in the array.
So say my variable $x = 3, I want to order the array starting with the number right after the $x. So the array would look like this now array(4,5,6,1,2,3). Is this even possible?
Another example if $x = 6, The array would be array(1,2,3,4,5,6). So basically order the array so that the set variable (in this case $x) will be at the end and the rest will run in order.

Greetings!

I would like to ask for you help sorting a couple of lists that are autogenerated with php.
The page reads a content of a folder and makes a menu from the names. The folder names a a, b, c, d... etc.

The other part reads the content of the selected folder and displays the files.

My problem is, that on windows, using xampp, the both the folders and files appear in alphabetic order (what I want), but on the linux server they get completely messed up.
Instead of a, b, its o, a, d, etc.
I tried using the sort() function but there is no array to sort...

Thank you for any suggestions and help!
Inka

ps. the server has php 4.3.9... does this matter? could help if we upgrade to 5.3?

here is the code:
Code: [Select]
<?php     
     $dh  = opendir($dir);

     while (false !== ($filename = readdir($dh))) {

       $files[] = $filename;

        if ($filename != "." && $filename != "..")
                     {    
        if($_SERVER['REQUEST_URI'] == "index.php?l=" . $filename . '&sec=' . $sec){
                     echo '<td><img src="imagini/arow.gif"></td><td style="text-align: left;">' . strtoupper($filename) . $space;
                     } else {    

            echo '<td style="text-align: left;"><a href="index.php?l='. $filename . '&sec=' . $sec . '">' . strtoupper($filename) . $space;                }}}

?>

<?php

    $letter = "a";

    if(isset($_GET["l"])){

    $letter = $_GET["l"];} 

    $letter = $dir . $letter;

 if ($handle = opendir($letter)) {

   while (false !== ($file = readdir($handle)))

      {

          if ($file != "." && $file != "..")

      {

     $filename = $file;
     $file2 = substr($filename, 0, -4);
     $thelist .= '<tr><td style="width: 250px; text-align: left;"><a href="'. $letter . '/'. $file.'">'.$file2.'</a></td></tr>';

          }
       }
  closedir($handle);
  }
?>
<p><?php echo $thelist; ?></p>

hello, i have the following, which is sorting by id number with a horizontal line between.  im trying to make it so that it is sorted by supplier with lines between each letter.

Code: [Select]
<?php

if ($PreviousID!=0 && $ManID != $PreviousID) {?>
                          <hr />
                          <?PHP }
                          $PreviousID = $ManID;
 
include 'config.php';
include 'javascript.php';


@mysql_select_db ("citycore", $conn) OR DIE (mysql_error());

$sql = "SELECT * FROM supplier ORDER BY supplier";
$result = @mysql_query($sql, $conn) or die(mysql_error());
//$row2 = mysql_query($sql, $conn);
$PreviousID=0;
while ($row = mysql_fetch_array($result)) {
  $ManID = $row['id'];
  $id=$row['id'];
  $supplier=$row['supplier'];
  $address=$row['address'];
  $city=$row['city'];
  $province=$row['province'];
  $postal=$row['postal'];
  $phone2=$row['phone2'];
  $phone=$row['phone'];
  $fax=$row['fax'];
  $email=$row['email']; 
 
?>
<div align="center">
                              <table border="1" width="95%" style="border-collapse: collapse">
                                <tr>
                                  <td><?php echo $row['supplier'];?></td>
                                  <td><a href="http://mapof.it/<?php echo($address .' ' .$city .',' .' ' .$province .' ' .$postal); ?>" target="_blank"><?php echo($address .' ' .$city .',' .' ' .$province .' ' .$postal); ?></a></td>
                                </tr>
                              </table>
                              </div>

 <?PHP  } ?>

I have the following php array structure and couldnot able to sort it according to the overall points. My code is reading an xml file using simplexml. Any help would be appreciated.

Array
(
    => SimpleXMLElement Object
        (
            [played] => 0
            [won] => 0
            [drawn] => 0
            [lost] => 0
            [overallpoints] => 0
        )

    [1] => SimpleXMLElement Object
        (
            [played] => 6
            [won] => 3
            [drawn] => 0
            [lost] => 3
            [overallpoints] => 9
        )

    [2] => SimpleXMLElement Object
        (
            [played] => 3
            [won] => 1
            [drawn] => 0
            [lost] => 2
            [overallpoints] => 3
        )

    [3] => SimpleXMLElement Object
        (
            [played] => 0
            [won] => 0
            [drawn] => 0
            [lost] => 0
            [overallpoints] => 0
        )

    [4] => SimpleXMLElement Object
        (
            [played] => 2
            [won] => 1
            [drawn] => 0
            [lost] => 1
            [overallpoints] => 3
        )
}

I am using the following code to sort by Year. It displays the current year fine and current year also displays in selection but does give the option for the previous years selection.

Code: [Select]
<form action="archivednews.php" method="post">
<select name="year" id="year">
<?PHP for($i=date("Y");
$i<=date("Y");
$i++)  
if($year == $i)
echo "<option value='$i' selected>$i</option>";
else
echo "<option value='$i'>$i</option>";
?>
</select>
<input type="submit" value="GO">
</form>

I have an array that looks like this...

Code: [Select]
Array (
    [0] => Array ( [0] => 2 [1] => Dylan Cross )
    [1] => Array ( [0] => 5 [1] => Bob Smith )
    [2] => Array ( [0] => 1 [1] => Sarah Park )
    [3] => Array ( [0] => 7 [1] => Jane Knowles )
    [4] => Array ( [0] => 6 [1] => Harry Hill )
    [5] => Array ( [0] => 3 [1] => Jack Rock )
)

How do I sort this array so it is ordered alphabetically by the names so the result will be...

Code: [Select]
Array (
    [0] => Array ( [0] => 5 [1] => Bob Smith )
    [1] => Array ( [0] => 2 [1] => Dylan Cross )
    [2] => Array ( [0] => 6 [1] => Harry Hill )
    [3] => Array ( [0] => 3 [1] => Jack Rock )
    [4] => Array ( [0] => 7 [1] => Jane Knowles )
    [5] => Array ( [0] => 1 [1] => Sarah Park )
)

Thanks

Is it possible to sort a table of mysql data, by using a variable?

I'm trying this:

Code: [Select]
<?php

$result = mysql_query("SELECT * FROM members ORDER BY '$totalpower'");
        echo "<table border='1' cellpadding='10'>";
               echo "<tr> 
<th>Rank</th> 
<th>Username</th> 
</tr>";

while($row = mysql_fetch_array($result))
  {
  
                echo "<tr>";
                echo '<td> </td>';
                echo '<td>' . $row['Username'] . '</td>';
                echo "</tr>"; 
  }
        echo "</table>";
?>
It display's a list of username's but not in the correct power order.

$totalpower is defined:

Code: [Select]
<?php

//power calculations

        $result = mysql_query("SELECT * FROM members WHERE Username='$_SESSION[Username]'")                 
        or die(mysql_error());       
        while($row = mysql_fetch_array( $result )) {   
            $power1 = $row['ounit1'] * 50;
$power2 = $row['ounit2'] * 70;
$power3 = $row['ounit3'] * 110;
$power4 = $row['ounit4'] * 200;
$power5 = $row['ounit5'] * 150;
$power6 = $row['ounit6'] * 300;
$power7 = $row['ounit7'] * 500;
$power8 = $row['ounit8'] * 450;
$power9 = $row['ounit9'] * 650;
$power10 = $row['ounit10'] * 350;
$power11 = $row['ounit11'] * 600;
$power12 = $row['ounit12'] * 1000;

$dpower1 = $row['dunit1'] * 50;
$dpower2 = $row['dunit2'] * 70;
$dpower3 = $row['dunit3'] * 110;
$dpower4 = $row['dunit4'] * 200;
$dpower5 = $row['dunit5'] * 150;
$dpower6 = $row['dunit6'] * 300;
$dpower7 = $row['dunit7'] * 500;
$dpower8 = $row['dunit8'] * 450;
$dpower9 = $row['dunit9'] * 650;
$dpower10 = $row['dunit10'] * 350;
$dpower11 = $row['dunit11'] * 600;
$dpower12 = $row['dunit12'] * 1000;

$dbase = $row['baselevel'] * 3000;
        }

$offencepower = $power1+$power2+$power3+$power4+$power5+$power6+$power7+$power8+$power9+$power10+$power11+$power12;
$defencepower = $dpower1+$dpower2+$dpower3+$dpower4+$dpower5+$dpower6+$dpower7+$dpower8+$dpower9+$dpower10+$dpower11+$dpower12+$dbase;
$totalpower = (($offencepower+$defencepower)/ 100 * 30) + $offencepower+$defencepower;

?>
Also how do I add auto numbers in the left column e.g 1. 2. 3. 4.

Thanks in advance.

Hello,

Hope somebody can help me.
I have an XML file that is generated by active directory that dumps everything required for a telephone directory.
I currently present this using XSL but would like to move towards PHP.

I have some rudimentary code and it's working fine but I'd like to be able to sort by various values, such as First Name or telephone number.

My XML format looks like this:

Code: [Select]
<?xml version="1.0" encoding="UTF-8"?>
<telephonelist>
   <employee>
      <firstname>Jimmy</firstname>
      <lastname>Jimmerson</lastname>
      <email>jimbo@companyxyz.com</email>
      <extensionnum>956</extensionnum>
      <jobtitle>Security Officer</jobtitle>
      <department>Security</department>
   </employee>
   <employee>
      <firstname>David</firstname>
      <lastname>Davidson</lastname>
      <email>David.Davidson@companyxyz.com</email>
      <extensionnum>968</extensionnum>
      <jobtitle>Manager</jobtitle>
      <department>Management</department>
   </employee>
Any my current code looks like this:

Code: [Select]
<?
$myStaffMembers = new SimpleXMLElement("includes/telephonelist.xml", null, true);

echo <<<EOF
<table width="95%" border="0">
  <tr>               
<th><b>First Name</b></th>               
<th><b>Last Name</b></th>               
<th><b>Telephone Number</b></th>               
<th><b>Position</b></th>                       
  </tr>
EOF;

foreach($myStaffMembers as $myStaffMember)
{
echo "     
  <tr>               
<td>{$myStaffMember->firstname}</td>               
<td>{$myStaffMember->lastname}</td>               
<td>{$myStaffMember->extensionnum}</td>               
<td>{$myStaffMember->jobtitle}</td>                       
  </tr>";
}
?>
Appreciate any help anybody could give.

Thanks,
LJ

I need to sort this:

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

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

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 - 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>';
}