sorting compled arrays

[scrypte]

Ok i'm reading from a file that likes look so:

GATE The Gate voodoo://chat.fearlab.net=GATE 0 250 0 GEN
POTTER harry potter net voodoo://chat.fearlab.net=POTTER 0 30 0 GEN
SYCOSI Syc0sis voodoo://chat.fearlab.net=SYCOSI 1 30 0 GEN
HANG H a N g O uT voodoo://chat.fearlab.net=HANG 0 30 0 GEN
GUYZ Syc0 Guyz voodoo://chat.fearlab.net=GUYZ 0 30 0 MEN
SOUTH Southern Comfort Music Room voodoo://chat.fearlab.net=SOUTH 0 30 0 MUS

its tab delimeted which isnt a problem, but when I do the for each statement , how can I make it sore by lets say $array[3] but throughout the entire file?

[Installer]

You could do it like (or very much like; it's untested) this:

$array = file('file.txt');
foreach ($array as $key => $line) {
    $array[$key] = explode("\t", $line);
    $tmp[] = $array[$key][3];
}
array_multisort($tmp, SORT_ASC, $array);

[Drakla]

Once you've got your final array of all rows use [man]uasort[/man] on it with a callback function that compares the nth element, something like

uasort($myarray, 'my_callback');

function my_callback($a, $b)
{
    return $a[3] > $b[3];
}

[scrypte]

Here is the coding im using:

<?  

function row_color($k){
    $bg1 = "#909090"; // color one    

    $bg2 = "#c0c0c0"; // color two

if ( $k%2 ) {
    return $bg1;
} else {
    return $bg2;
}
} 


// create a loop that will read all elements of the array and print out
// each field of the tab-delimited text file
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"2\" width=\"650\" align=\"center\">
<tr>
<td width=\"30\" class=\"header\">Number </td>
<td width=\"300\" class=\"header\">Room Name</td>
<td width=\"20\" class=\"header\">Users</td>
</tr>";
for ($k=0; $k<=count($readfile)-1; $k++) {

$fields = split("\t",$readfile[$k]);	

echo "
<tr>
<td width=\"30\" class=\"info\" bgcolor=".row_color($k).">$k</td>
<td width=\"300\" class=\"info\" bgcolor=".row_color($k)."><a href=$fields[2]>$fields[1]</a></td>
<td width=\"20\" class=\"info\" bgcolor=".row_color($k).">$fields[3]</td>
</tr>
";


}
echo "
    <tr>
    <td colspan=3 class=\"footer\" align=right>Total Rooms: $k</td>
    </tr>
    </table>";

?>

[Drakla]

You're going to have to change it and grab all the data into an array so it can be sorted by Installer's or my method. [man]fgetcsv[/man] might help you along the way.

[scrypte]

ok i'm starting over again with my coding.

<?  

$readfile = file("../../voodoo/rooms.txt");

echo "<pre>";
print_r($readfile);
echo "</pre>";

?>

I get this:

Array
(
    [0] => GATE	The Gate	voodoo://chat.fearlab.net=GATE	0	250	0	GEN

[1] => POTTER	harry potter net	voodoo://chat.fearlab.net=POTTER	0	30	0	GEN

[2] => SYCOSI	Syc0sis	voodoo://chat.fearlab.net=SYCOSI	1	30	0	GEN

[3] => HANG	H a N g O uT	voodoo://chat.fearlab.net=HANG	0	30	0	GEN

[4] => GUYZ	Syc0 Guyz	voodoo://chat.fearlab.net=GUYZ	0	30	0	MEN

[5] => SOUTH	Southern Comfort Music Room	voodoo://chat.fearlab.net=SOUTH	0	30	0	MUS

[6] => CROSS	The Crossing	voodoo://chat.fearlab.net=CROSS	0	30	0	GEN

[7] => SHELLY	_shelley_'s Room	voodoo://chat.fearlab.net=SHELLY	0	30	2	GEN

[8] => IDOL	syc0idol	voodoo://chat.fearlab.net=IDOL	0	30	0	GEN

[9] => AUCTIO	Syc0sis Auction	voodoo://chat.fearlab.net=AUCTIO	0	60	0	GEN
)

Now I need to go down one more level, how can I do that?

[Drakla]

Now you need to turn the entries for each line into their own arrays - so do a foreach on it and explode them on tabs and assign that back to the same element. This will get you to the array of arrays you need to use in the sorting function.

foreach ($readfile as $k => $v)
{
	$readfile[$k] = explode("\t", $v);
}

compare that to Installer's code above. You can now either run the method I showed you on it - use a string comparison function in the callback if you'll be comparing strings, or split the required columns off and use array_multisort like in Installer's method.

[scrypte]

Ok I am still having trouble grouping the entire array properly, its still splitting it up by row:

Array
(
    [0] => Array
        (
            [0] => GATE
            [1] => The Gate
            [2] => voodoo://chat.fearlab.net=GATE
            [3] => 0
            [4] => 250
            [5] => 0
            [6] => GEN

    )

)

Array
(
    [1] => Array
        (
            [0] => POTTER
            [1] => harry potter net
            [2] => voodoo://chat.fearlab.net=POTTER
            [3] => 0
            [4] => 30
            [5] => 0
            [6] => GEN

    )

)

I need it to do this:

Array
(
    [0] => Array
        (
            [0] => GATE
            [1] => The Gate
            [2] => voodoo://chat.fearlab.net=GATE
            [3] => 0
            [4] => 250
            [5] => 0
            [6] => GEN

    )
[1] => Array
    (
        [0] => POTTER
        [1] => harry potter net
        [2] => voodoo://chat.fearlab.net=POTTER
        [3] => 0
        [4] => 30
        [5] => 0
        [6] => GEN

    )

)

here is the new coding:

<?  

$readfile = file("../../voodoo/rooms.txt");

foreach ($readfile as $k => $v ) {	

$readfile = array($readfile[$v][$k] = split("\t", $v));

echo "<pre>";
print_r($readfile);
echo "</pre>";

} 

?>

[scrypte]

I Know this should work, but why doesnt it?

<?  

function row_color($k){
    $bg1 = "#909090"; // color one    

    $bg2 = "#c0c0c0"; // color two

if ( $k%2 ) {
    return $bg1;
} else {
    return $bg2;
}
} 


?>
<table border=0 cellspacing=0 cellpadding=2 width=550 align=center>
<tr>
<td width=300 class=header>Room Name</td>
<td width=20 class=header>Users</td>
</tr>
<?
// sort function
function my_callback($a, $b)
{
    return $a[$key][3] < $b[$key][3];
} 

$array = file("../../voodoo/rooms.txt");
$output = array();
foreach($array as $key=>$value)
{
    $output[] = explode("\t", $value);
    uasort($output, 'my_callback');

print_r('<tr>');
print_r('<td width=300 class=info bgcolor='.row_color($key).'>');
print_r('<a href='.$output[$key][2].'>'.$output[$key][1].'</a></td>');
print_r('<td width=20 class=info bgcolor='.row_color($key).'>'.$output[$key][3].'</td>');
print_r('</tr>');
}

?>
</table>

For some reason its still not sorting the array