|
|
Posted by Brent Baisley on 06/06/05 17:08
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
Navigation:
[Reply to this message]
|