arrays... and long-term-novice

[Ja NE]

I need to sort some values by percentage, and don't know how...

here is where I got so far:

mysql_query("SELECT sum($usage)...
list($total)... // now I have total number I need to find %

mysql_query...
while(list($id,$usage) = mysql_fetch_array)) {
mysql_query("SELECT sum($usage) WHERE id=$id...
list($used)... // now I have some usage for each $id

$made = sprintf("%.f", $used / $total * 100);

echo"$id $made<br>"; //will output:

101 @ 50.38%
102 @ 25.19%
103 @ 24.43%

and I want to deal with the last only from this example. with the one of
smallest percentage and I can't know which one will that be.

I think I have to create and sort array, but whatever I have made, I had
no success.
if I create array inside of while{} I end with 3 different arrays.
if I end while {} I have only one to work with...

can anyone help me? (I have avoided arrays so far with "great" success,
but from now on, I just have to use them and I don't understood them at
all. my english isn't that good, and haven't find proper documentation
on my language to learn)

tnx in advance

--
Ja NE
http://fotozine.org/?omen=janimir
--

[Geoff Berrow]

A waste of electrons? You decide, but Message-ID:
<1h****************************@mail.zz> from Ja NE contained the
following:

$made = sprintf("%.f", $used / $total * 100);

Arrays are easy and incredibly useful

Try something like:

//create an array using the id as the key and %age as value
$made[$id]=$used / $total * 100;

in your while loop.

Sort the array in reverse order

arsort($made);

and outside the loop echo it to the screen

foreach ($made as $key=>$value){
echo $key." @ ".number_format($value,2)."%<br>";
}
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Steve]

I need to sort some values by percentage, and don't know how...

Let MySQL do the work for you:

SELECT @TOT:=SUM( `usage` )
FROM mytable

and in the same session, calculate all the percentages and return just
the first one:

SELECT `usage`, `usage` / @TOT AS `perc`
FROM mytable
ORDER BY `perc`
LIMIT 1

No need to learn about arrays just yet 8-)

---
Steve

[Ja NE]

Geoff Berrow <bl******@ckdog.co.uk> wrote:

thank you, that helped with little addon:

$i=0;
foreach ($made as $key=>$value){
$i++
processing (with_job);
if ($i == 1) {
break; //had to deal with the one only
}
}
--
Ja NE
http://fotozine.org/?omen=janimir
--

[Ja NE]

Steve <go********@nastysoft.com> wrote:

SELECT @TOT:=SUM( `usage` )
FROM mytable

SELECT `usage`, `usage` / @TOT AS `perc`
FROM mytable
ORDER BY `perc`
LIMIT 1

No need to learn about arrays just yet 8-)

Thank you Steve, will try that latter too. php solution have olready
went on site...

--
Ja NE
http://fotozine.org/?omen=janimir
--

[Geoff Berrow]

A waste of electrons? You decide, but Message-ID:
<1h****************************@mail.zz> from Ja NE contained the
following:

foreach ($made as $key=>$value){
$i++
processing (with_job);
if ($i == 1) {
break; //had to deal with the one only
}
}

wouldn't this work?

foreach ($made as $key=>$value){

processing (with_job);

break;

}

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Ja NE]

Geoff Berrow <bl******@ckdog.co.uk> wrote:

wouldn't this work?
I don't know... how would "script knew" when to break?

foreach ($made as $key=>$value){

processing (with_job);

break;

}

--
Ja NE
http://fotozine.org/?omen=janimir
--

[Geoff Berrow]

Message-ID: <1h****************************@mail.zz> from Ja NE
contained the following:

I don't know... how would "script knew" when to break?

Seems to work fine.

$array=array(101=>"25",102=>"35",103=>"30");

arsort($array);

foreach ($array as $key=>$value){

//do some processing
print"<p>Key is:$key Value is: $value</p>";
break;

}

print "All done";

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/