PHP - Php Sorting Issue

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

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

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

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?

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

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?

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

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

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

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

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

The following code works, but I need to take it a step further and I'm not sure how. What I'd like to do is sort the output so the highest point totals get printed first (along with the associated information). Can anyone help?

Here's the site:

http://www.beat-the-spread.net/seasontotals.php


Here's the code:
Code: [Select]
$i=1;
$w=1;
$result = mysql_query( "
SELECT team_name, owner
FROM teams" );
while ($row = mysql_fetch_array($result))
{
echo "<tr>\n",
"</td><td>",
$row['owner'],
"</td><td>",
$row['team_name'];

$result1 = mysql_query( "
SELECT bye, owner_pts
FROM schedule
WHERE team = $i");
$num_rows = mysql_num_rows($result1);

while ($row1 = mysql_fetch_array($result1))
{

$totalpts = $totalpts + $row1['owner_pts'];

if (empty($row1['bye']))
{
echo "</td><td>", $row1['owner_pts'], "</tr>\n";
}
else
{
echo "</td><td>","0","</tr>\n";
}

}

while ($num_rows<=16)
{
echo "</td><td>","","</tr>";
$num_rows++;
}

echo "</td><td>","$totalpts","</tr>";
$totalpts=0;
$w++;
$i++;
}

echo "</table>\n";

mysql_close($con);


Thanks!

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