454,723 Members | 1,414 Online Need help? Post your question and get tips & solutions from a community of 454,723 IT Pros & Developers. It's quick & easy.

# Group an array

 P: n/a i have the following array: Array (  =Array (  =Leamore Windows Ltd  =553398833511417  =20 )  =Array (  =HRPC  =920589205210538  =1 )  =Array (  =Leamore Windows Ltd  =553398833511417  =2 ) ) is it possible to group the items in the array and order by name to output the following: Array (  =Array (  =HRPC  =920589205210538  =1 )  =Array (  =Leamore Windows Ltd  =553398833511417  =22 ) ) Jan 29 '07 #1
6 Replies

 P: n/a cr*************@gmail.com wrote: i have the following array: Array (  =Array (  =Leamore Windows Ltd  =553398833511417  =20 )  =Array (  =HRPC  =920589205210538  =1 )  =Array (  =Leamore Windows Ltd  =553398833511417  =2 ) ) is it possible to group the items in the array and order by name to output the following: Array (  =Array (  =HRPC  =920589205210538  =1 )  =Array (  =Leamore Windows Ltd  =553398833511417  =22 ) ) Hi, Have a look at usort() http://nl2.php.net/manual/en/function.usort.php With usort you can define your own sortingrules. Regards, Erwin Moller Jan 29 '07 #2

 P: n/a On Mon, 29 Jan 2007 06:07:48 -0800, Erwin Moller i have the following array:Array(  =Array (  =Leamore Windows Ltd  =553398833511417  =20 )  =Array (  =HRPC  =920589205210538  =1 )  =Array (  =Leamore Windows Ltd  =553398833511417  =2 )) is it possible to group the items in the array and order by name tooutput the following:Array(  =Array (  =HRPC  =920589205210538  =1 )  =Array (  =Leamore Windows Ltd  =553398833511417  =22 ) ) Hi, Have a look at usort() http://nl2.php.net/manual/en/function.usort.php With usort you can define your own sortingrules. Regards, Erwin Moller The OP may want array_unique. After which, they could sort. @the OP: you'll probably have to write a recursive function using array_unique to handle multi-dimensional arrays. -- Curtis Jan 30 '07 #3

 P: n/a On 30 Jan, 10:56, Curtis

 P: n/a On Jan 30, 12:31 pm, "strawberry" i have the following array: >Array >( >  =Array > ( >  =Leamore Windows Ltd >  =553398833511417 >  =20 > ) >  =Array > ( >  =HRPC >  =920589205210538 >  =1 > ) >  =Array > ( >  =Leamore Windows Ltd >  =553398833511417 >  =2 > ) >) >is it possible to group the items in the array and order by name to >output the following: >Array >( >  =Array > ( >  =HRPC >  =920589205210538 >  =1 > ) >  =Array > ( >  =Leamore Windows Ltd >  =553398833511417 >  =22 > ) >) Hi, Have a look at usort() >http://nl2.php.net/manual/en/function.usort.php With usort you can define your own sortingrules. Regards, Erwin MollerThe OP may want array_unique. After which, they could sort. @the OP: you'll probably have to write a recursive function using array_unique to handle multi-dimensional arrays. -- Curtis The tips provided look very useful - but i wonder where the data's actually coming from? If it's from a sql database then it would far simpler to do the manipulations there.- Hide quoted text - - Show quoted text - the result is produced from 2 separate queries producing results from 2 separate tables. I appreciate that it would be easier to manipulate from the sql leayer but the tables contain individual data elements. Jan 31 '07 #5

 P: n/a On 31 Jan, 08:49, craig.keight...@gmail.com wrote: On Jan 30, 12:31 pm, "strawberry"

 P: n/a On Jan 31, 9:53 am, "Captain Paralytic" wrote: On 31 Jan, 08:49, craig.keight...@gmail.com wrote: On Jan 30, 12:31 pm, "strawberry" i have the following array: >Array >( >  =Array > ( >  =Leamore Windows Ltd >  =553398833511417 >  =20 > ) >  =Array > ( >  =HRPC >  =920589205210538 >  =1 > ) >  =Array > ( >  =Leamore Windows Ltd >  =553398833511417 >  =2 > ) >) >is it possible to group the items in the array and order by name to >output the following: >Array >( >  =Array > ( >  =HRPC >  =920589205210538 >  =1 > ) >  =Array > ( >  =Leamore Windows Ltd >  =553398833511417 >  =22 > ) >) Hi, Have a look at usort() >http://nl2.php.net/manual/en/function.usort.php With usort you can define your own sortingrules. Regards, Erwin MollerThe OP may want array_unique. After which, they could sort. @the OP: you'll probably have to write a recursive function using array_unique to handle multi-dimensional arrays. -- Curtis The tips provided look very useful - but i wonder where the data's actually coming from? If it's from a sql database then it would far simpler to do the manipulations there.- Hide quoted text - - Show quoted text - the result is produced from 2 separate queries producing results from 2 separate tables. I appreciate that it would be easier to manipulate from the sql leayer but the tables contain individual data elements.- Hide quoted text - - Show quoted text - So do a UNION!- Hide quoted text - - Show quoted text - Thanks, but i didn't know of the UNION syntax in mysql. Its seems to work for me. Thanks again Jan 31 '07 #7

### This discussion thread is closed

Replies have been disabled for this discussion. 