Learn VBA & Macros in 1 Week!

PHP - Array Sorting / Mysql Problem

Full Excel VBA Course - Beginner to Expert

Array Sorting / Mysql Problem	View Content

Hi guys, this is my first post so be nice!

I have an SQL select which returns the following

cat_id cat_name parent_id 1 cat 1 0 2 cat 2 0 3 cat 3 0 4 cat 4 0 5 cat 5 1 6 cat 6 1 7 cat 7 0
The above shows that category 1 has 2 children.

I have a script in place that basically filters the child entries into a new array, then I use two foreach loops to build a list of items with parent > child relationship.

My code works, but is a mess and doesn't 'feel' as concise as it should be.

What would be the best / most efficient way to build a child > parent list. (ideally i would want it to work on up to 4 tiers)

Any help would be greatly appreciated.

Cheers

Dave

Full Excel VBA Course - Beginner to Expert

Sorting Mysql Data Based On An Array

Similar Tutorials

View Content

I'm working on a store locator style program. I first get and sort all zip codes based on a their distance to an original location. I then use that zip code array to find all stores in the mysql database, but when I get the results, they're no longer arranged by distance from the original location.. and I can't just sort them ascending or descending based on their zip codes because that doesn't sort them correctly either.

So I need to sort the data I get from the mysql database based on their "zip_code" column and in order from the $zip array..

Here's an example of what $zip looks like.. the zip code is the key and the distance from the original zip is the value [meaning the first key is the $originalZip]:
Array (
[70601] => 0
[70616] => 1.12
[70629] => 1.2
[70612] => 1.24
[70602] => 1.31
[70615] => 1.88
[70609] => 3.41
[70605] => 4.4
[70669] => 4.62
[70606] => 4.9
[70611] => 7.23
[70607] => 9.68
[70663] => 9.74
)

and then I create the $WHERE variable by each key supplied:
$WHERE = "WHERE zip_code='$originalZip'";

foreach ($zip as $key => $value) {
if ($key == $originalZip) {}
else { $WHERE .= " OR zip_code='$key'"; }
}
}

Then I do the query [with a paginator]:
$query = query("SELECT * FROM " . $db['prefix'] . "stores $WHERE LIMIT $from, $maxResults");

but when I print the data, it doesn't keep the correct sorting format..
if (mysql_num_rows($query) > 0) {
for ($i = 0; $i<mysql_num_rows($query); $i++) {
$storeData = mysql_fetch_array($query, MYSQL_ASSOC);
// print store information here such as $storeData['name'] $storeData['address'] $storeData['zip_code']
} }

Is there an easy way to sort the mysql results based on the $zip array?

Sorting Mysql Results Using Values From An Array?

Similar Tutorials

View Content

Say I have a table called artists with these fields (artistid, rank). Then say I have an array called $rankadjustments with a value for each artist (like 1, 7, 3,-3, 5, 9, etc). I am doing a MYSQL query that gets the info from artists table and sorts according to the rank field like this...

$sql = "SELECT * FROM artists ORDER BY rank";

Easy enough. But what if I would like to bring that data back sorted by (rank + rankadjustment). For example, if the artist ranked 1st had a rank of "1" from mysql, but had a rankadjustment of "5" from the rankadjustment array, his "true" rank would be "6". Again, rankadjustment is NOT a field in my table, otherwise it would obviously be simple. It's calculated on the fly and stored in an array. FYI, the array has an index with their "artistid". For example, $rankadjustment[341][8] would be the artist with an artistid of "341" has a rank adjustment of 8. Is there a way to do this IN the query itself? It doesn't seem possible but wanted to find out for sure. If not, what is best way to do? I assume... Get the data sorted JUST by rank and put it all into an array, then create a new array that adds rank to rankadjustment and reorder by the "new" rank amount? I guess that wouldn't be too bad but again, wanted to make sure I'm not missing something that would allow me to do it all in the query (or just more efficiently). Thanks!
Edited by galvin, 21 December 2014 - 09:13 PM.

Mysql Array Problem

Similar Tutorials

View Content

I have an array of data from a mysql result. The problem I have is that I want to find out what the next row is going to be in advanced. At the moment I have

Code: [Select]
while($row = mysql_fetch_assoc($rs) {

echo 'Order ID: ' . $row['order_id'];

}

This just echo's out the order_id of the current row. However I want to find out if the order_id on the next row is going to be the same or different. If it's different I will want to echo out something else.

Code: [Select]
while($row = mysql_fetch_assoc($rs) {

echo 'Order ID: ' . $row['order_id'];

//If order_id + 1 is different then echo
echo 'Total: ' . $row['total']

}

Does anyone know a way round this problem?

Thanks

Sorting An Array

Similar Tutorials

View Content

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

Need Help Sorting An Array - Please Help

Similar Tutorials

View Content

Php Array Sorting

Similar Tutorials

View Content

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
)

)

Help With Sorting A 2d Array

Similar Tutorials

View Content

Hello!

I have a 2D array that look as follows:

$test["name"][0] = "arnold";
$test["name"][1] = "nate";
$test["name"][2] = "steve";

$test["id"][0] = 2;
$test["id"][1] = 0;
$test["id"][2] = 1;

This means arnold has an ID of 2, nate has an ID of 0 and steve has an ID of 1.
Now I want to sort the array based on the ID value, so I want to achieve the following result:

$test["name"][0] = "nate";
$test["name"][1] = "steve";
$test["name"][2] = "arnold";

How would I achieve this? Help much appreciated.

Sorting Array

Similar Tutorials

View Content

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

Array Sorting By Value

Similar Tutorials

View Content

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?

Sorting An Array...

Similar Tutorials

View Content

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

Sorting An Array

Similar Tutorials

View Content

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!

Sorting Php Array

Similar Tutorials

View Content

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

Array Sorting

Similar Tutorials

View Content

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

Php Sorting Mysql

Similar Tutorials

View Content

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

Sorting An Array By Date.

Similar Tutorials

View Content

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

Sorting Multidimensional Array

Similar Tutorials

View Content

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.

Sorting A Multidimensional Array

Similar Tutorials

View Content

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.

Sorting Multidimensional Array

Similar Tutorials

View Content

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.

Sorting Complex Array

Similar Tutorials

View Content

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?

Array Sorting Issue

Similar Tutorials

View Content

Generally I am able to help my self on the forums. But, this one has me stumped. I've done it before and I don't remember it being this hard. The array looks something like so

$users['id'] = '00001','00002','0003'
$users['jobs'] = '22','322','112'
$users['connected'] = '12','210','89'
$users['percent'] = '54','65','89'

I've used so much different things to try and take those, keep the data together (index 0 might be moved to 2, but all values from 0 are moved to 2) and sort by 'percent'. So I can display the person that has the highest percentage first. Basically the data was originally a CSV that is now in a database and is pulled, percentages calculated and then displayed. But the order is off. There is a bunch more data then show but I'm using PHP to do all the math for adding up jobs, seeing whats connected right and then coming up with a percentage, sticking it all in an array so I can sort it; but for some reason I cannot remember how I've done this before.