Re: Implode? Explode?

You're close, but you need to group your data on the series_id first. You can do that by looping through your array and creating another array using series_id as the array key. You'll end up with a list of arrays named after the series_id. foreach( $result_set as $result_item ) { //Add an array item to the series_id slot of the grouped_result array $grouped_result[ $result_item['series_id'] ][] = array('id'=>$result_items['art_id'], 'title'=>$result_item['art_title']); } Now you have your data grouped by series_id. Each item of the grouped_result array will contain one or more arrays which contain the art_id and art_title. If you are not familiar with multidimensional arrays, this may be a little confusing. On Jun 6, 2005, at 8:32 AM, Jack Jackson wrote:

Hi all, I'm trying to fetch similar things - in this case, rows which share a series ID no - and bring them into an array and display them grouped by what makes them similar (in this case, series id). I looked at implode and explode which seem wrong for this - the only separator I can see is that they're each in a table cell. The result of my query returns something like:

art_id   series_id     art_title            series_name
2 	1 	       Weddings 2004        Summer Special
4 	1 	       Summer In The City   Summer Special
5       2              Bags of NY           Op-Art
7       2              Dogs of NY           Op-Art

I'd like to create a list of links to each art_id grouped together as series, href code obviously not complete but demonstrative: <p>Summer Special<br /> <a href='2'>Weddings 2004</a> | <a href='4'>Summer In The City</p> <p>Op-Art<br /> <a href='5'>Bags of NY</a> | <a href='7'>Dogs of NY</p> ? Thanks in advance, Jack -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577