Multi Dimensional array sorting on number

timon

Well here is my problem.

I gathering a country and how many times it is in the table.

Well I did it with this query

"SELECT COUNTRY, COUNT() FROM table GROUP BY COUNTRY"
So for example
COUNTRY COUNT()
USA 12
Brazil 15
Netherlands 10
Belgium 5

hmm actually it sorts it but never the less not important now.

No I want to sort it on COUNT().
I tried it with a array (a multi dimensional array).
But the problem with those darn arrays is when you are filling it like this
$TEST[0][0] = "$COUNT() $COUNTRY";
But the problem is that $COUNT(*) will be a string instead of a int when I use any sort() function.

So my question how to solve it?

Any great ideas? lemme know 🙂

volleytotal_ch

have you tried this? may be your solution 😉

$query = "SELECT COUNTRY, COUNT(*) as count FROM table GROUP BY COUNTRY ORDER BY count";

btw: it's faster to use a specific col for the count thing! example:

$query = "SELECT country, COUNT(a_col) as count FROM table GROUP BY country ORDER BY count";

trooper

I think you need to create an alias for the COUNT(*) and then order by the alias

so
"SELECT COUNTRY, COUNT(*) as counter FROM table GROUP BY COUNTRY ORDER by counter DESC" should work

Originally posted by timon
Well here is my problem.

I gathering a country and how many times it is in the table.

Well I did it with this query

"SELECT COUNTRY, COUNT() FROM table GROUP BY COUNTRY"
So for example
COUNTRY COUNT()
USA 12
Brazil 15
Netherlands 10
Belgium 5

hmm actually it sorts it but never the less not important now.

No I want to sort it on COUNT().
I tried it with a array (a multi dimensional array).
But the problem with those darn arrays is when you are filling it like this
$TEST[0][0] = "$COUNT() $COUNTRY";
But the problem is that $COUNT(*) will be a string instead of a int when I use any sort() function.

So my question how to solve it?

Any great ideas? lemme know 🙂

timon

I tried the first one, it worked well.

But the second gives me error. Maybe because of the windows edition of PHP. dunno. Have noticed several problems with this edition. Well it's solved now. THX!

trooper

thats strange the only difference it that one has the DESC in it

I checked it out on my windoze box before sumitting it

hmmmmm

timon

The one I ment was

$query = "SELECT country, COUNT(a_col) as count FROM table GROUP BY country ORDER BY count";

The a_col does not work somehow. Well but it works fine now without the a_col 🙂

You wrote your reply when I replyed. Thanks anyways :-)

volleytotal_ch

the 'a_col' was just an example "a col" - i meant that you insert a col name of the table you're using 😉

timon

oh boy how stupid can a human be? 😉