uasort with a text database - a tough one!

Siggles

Hi, I have a piece of code that takes a comma delimited text file and prints it line for line. It works brilliantly. Now what I want to do is sort the text file/array so that it prints them in order of the price field eg, £100 then £150 then £300 and so on.

Here is the code as it stands:

code:

$array = file('xfile1.txt');
$anything=array_shift($array);
foreach($array as $row) {
$line = explode('","', $row);

print $line[3] HTML HTML etc etcetc etc

Can you help?

I have tried

code:

<?php

function priceCmp($a, $b){
if ($a[7] == $b[7])return 0;
if ($a[7] < $b[7])return 1;
}

$array = file('xfile1.txt');
$anything=array_shift($array);
uasort($row, priceCmp);
foreach($array as $row) {
$line = explode('","', $row);

ect etc

but this doesnt seem to work. 7 by the way is the 8th thing along the comma delimited line which is the pricce eg, address,dsfsd,dfsdf,dfsedf,sdfsdf,sdfsdf,sdfdsf,PRICE,sfdsdf.

Thanks

Richard

amansabharwal

store all your data into arrays column wise and use

array_multisort ( array ar1 [, mixed arg [, mixed ... [, array ...]]])

to sort the data and then display it as you want

aman

Siggles

Thanks, but is there any way to do it using the current code?

Surely it must be possible. Is the function Im using incorrect?

😕

Siggles

Anybody? Please help?

The text file is here

Thanks

Siggles

Just in case anyone is interested, someone at www.the-pit.net (very helpful) managed to sove my problem. The code I use is

<?php

function priceCmp($a, $b){
$a1=explode('","',$a);
$b1=explode('","',$b);
if ($a1[7] == $b1[7])
return 0;
else if ($a1[7] > $b1[7])
return 1;
else return -1;
}

$array = file('xfile.txt');
$anything=array_shift($array);
uasort($array, priceCmp);
foreach($array as $row) {
$line = explode('","', $row);

It works brilliantly. You can show the records in price order, highest or lowest first just by changing > for < and vice versa.