Longest query of my life

mysql -H -u mauj -p mauj -e “select count(*) as DownloadCount,W.phone as PhoneModel,sum(W.un) as NumberOfUser from (select count(*) as un,mo ,phone from wap_tran_1 where servid=1 and type=3 and ts like ‘%2008-01%’ group by phone,mo UNION select count(*) as un,mo ,phone from wap_tran_2 where servid=1 and type=3 and ts like ‘%2008-01%’ group by phone,mo UNION select [...]

26/11 terror attack

array_multisort in php

Today i have used array_multisort function of php , its very easy …
I got a array, may be assoaciative example $name_array = (
[0] = array
(
[id] => 1,
[name] = > pravin
)
[1] = array
(
[id] => 2,
[name] = > navin
)
// and so on
)
// for sorting is by name alphabetically , we will use array_multisort();
first we will [...]