PHP - Function Sorting

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

First of all I am very new to php. I have coded in asp for years but have made the switch so I kinda know what I want to do but I am unsure on how to achieve it.


I have a css menu that I am trying to populate through a database. The parent tabs are in a standard list.  The first child submenu is in sepearate unordered list and anymore child tabs are within that list. Like this.

Code: [Select]
<div id="ddtopmenubar"  style="width: 960px">
<ul>
<li><a href="?page=">HOME </a></li>
<li><a href="?page=About" rel="">ABOUT </a></li>
<li><a href="?page=Services" rel="SERVICES">SERVICES </a></li>
<li><a href="?page=Governance" rel="GOVERNANCE">GOVERNANCE </a></li>
<li><a href="?page=Events">EVENTS </a></li>
<li><a href="?page=Contact">CONTACT </a></li>
</ul>
<ul id="SERVICES" class="ddsubmenustyle">
<li><a href="?page=Health">Health/Dental</a></li>
<li><a href="?page=Identification">International Student Identification Card</a></li>
<li><a href="?page=Employment">Student Employment</a></li>
               <li><a href="?page=Saver">Student Saver</a></li>
<li><a href="#">Other Services</a>
<ul>
<li><a href="#">Emergency Student Loan Fund</a></li>
<li><a href="#">Legal Services</a></li>
<li><a href="#">Parking Permits</a></li>
<li><a href="#">Homes4Students</a></li>
</ul>
</li>
</ul>
<ul id="GOVERNANCE" class="ddsubmenustyle">
<li><a href="?page=Council">Your Council</a></li>
<li><a href="?page=Executive">Executive</a></li>
<li><a href="?page=Committees">Committees</a></li>
<li><a href="?page=Constitution">Constitution/By-Laws</a></li>
<li><a href="?page=Minutes">Minutes</a></li>
<li><a href="?page=Elections">Elections</a></li>
</ul>
</div>

I am trying to populate this from a database list the results come ordered like this
Code: [Select]
1.0
2.0
3.0
3.1
3.2
3.3
3.4
3.4-1
3.4-2
3.4-3
3.4-4
4.0
4.1
4.2
4.3
4.4
4.5
4.6
5.0
6.0
where the "." show the 1st childs and the "-" show the 2nd child

I tried to do this by splting each line and determining if it is a zero or not if it was a zero i put that paticular one into an array to be used in the sub menu however this did not work out. Any ideas?

Hi! I am absolute noob in php, but need to create descending sorting by last modified/date. How I could achieve this? Many thanks for help!

 

echo '<table class="wp-list-table widefat fixed striped" style="max-height: 500px;overflow-y:scroll;">';
                        echo '<thead>';
                            echo '<tr>';
                                echo '<th>' . __( 'File Name', 'edd_s3' ) . '</th>';
                                echo '<th>' . __( 'Size', 'edd_s3' ) . '</th>';
                                echo '<th>' . __( 'Last Modified', 'edd_s3' ) . '</th>';
                                echo '<th>' . __( 'Owner', 'edd_s3' ) . '</th>';
                                echo '<th>' . __( 'Actions', 'edd_s3' ) . '</th>';
                            echo '</tr>';
                        echo '</thead>';

                        if ( $total_items > 0 ) {
                            echo '<tbody>';

                            foreach ( $files as $key => $file ) {

                                if ( ! isset( $file['name'] ) ) {
                                    continue;
                                }

                                if ( '/' === $file['name'][ strlen( $file['name'] ) - 1 ] || 'NextMarker' === $key ) {
                                    continue; // Don't show folders.
                                }

                                echo '<tr>';
                                if ( $i == 0 ) {
                                    $first_file = $key;
                                }

                                if ( $i == 29 ) {
                                    $last_file = $key;
                                }

                                if ( $file['name'][ strlen( $file['name'] ) - 1 ] === '/' ) {
                                    continue; // Don't show folders
                                }

                                $sizes     = array( 'bytes', 'KB', 'MB', 'GB' );
                                $factor    = floor( strlen( $file['size'] - 1 ) / 3 );
                                $file_size = sprintf( '%.2f', $file['size'] / pow( 1024, $factor ) ) . ' ' . $sizes[ $factor ];

                                echo '<td>' . $file['name'] . '</td>';
                                echo '<td>' . $file_size . '</td>';
                                echo '<td>' . date( 'j M Y H:i:s', $file['time'] ) . '</td>';
                                echo '<td>' . $file['owner'] . '</td>';
                                echo '<td><a class="insert-s3 button-secondary" href="#" data-s3="' . esc_attr( $file['name'] ) . '">' . __( 'Use File', 'edd_s3' ) . '</a></td>';
                                echo '</tr>';
                                $i++;
                            }
                            echo '</tbody>';
                        }

                        echo '</table>';
                    } else {
                        echo '<div class="error">';
                            echo '<p>' . __( 'No files have been uploaded to Amazon S3 yet. Upload one now!', 'edd_s3' ) . '</p>';
                        echo '</div>';
                        exit;
                    }

                    $base = admin_url( 'media-upload.php?post_id=' . absint( $_GET['post_id'] ) . '&tab=s3_library' );

                    if ( $bucket ) {
                        $base = add_query_arg( 'bucket', $bucket, $base );
                    }

                    echo '<div class="s3-pagination tablenav">';
                        echo '<div class="alignleft">';
                            if ( isset( $_GET['p'] ) && $_GET['p'] > 1 ) {
                                echo '<a class="button-secondary prev" href="' . esc_url( remove_query_arg( 'p', $base ) ) . '">' . __( 'Start Over', 'edd_s3' ) . '</a>';
                            }

                            if ( isset( $files['NextMarker'] ) ) {
                                $last_file = $files['NextMarker'];
                            }

                            if ( $i >= 29 || isset( $files['NextMarker'] ) ) {
                                echo '<a class="button-secondary next" href="' . esc_url( add_query_arg( array( 'p' => $page + 1, 'start' => $last_file ), $base ) ) . '">' . __( 'View More', 'edd_s3' ) . '</a>';
                            }
                        echo '</div>';
                    echo '</div>';
                }
                ?>
            </div>
            <?php
        }

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

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

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

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

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.

I'm attempting to create a SQL command that can sort through a concatenated string in my database it is listed at   Colors: blue,red,green,yellow is SELECT * FROM `shoes` WHERE CONCAT(',',color,',') LIKE '%,blue,red%' How do I filter the data where it can come up with shoes that are available in red or blue or red and blue and so on? I could use where find_in_set('blue', colors) > 0 and find_in_set('red', colors) > 0 Is there a better way of doing this?  Shoe name: shoe A
Shoe size: 7,8,9 Shoe color:  black , brown, grey

For example could have a shoe available in black , size 8 or 9 or 8 and 9.

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?

This topic has been moved to PHP Applications.

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

Hi!   I have this problem that I have to solve in PHP. I have such a difficult with this programming and I would be so grateful if someone could help me solve this. The problem: A lecturer has a group of students who need to be assigned to one of two groups for the

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>