RE: [PHP] Array problem

On 17 October 2007 12:09, Merlin wrote:

> Hi there,
>
> I am pulling picture ids out of a db and comment ids. The comments
> belong to the pic ids and are stored in two seperate tables.
> I am having trouble with the arrays to display them after
> pulling out of
> the db.
>
> The data is filled like this:
>
> while (rows etc.){
> $comment_id[$row->pic_id][] = $row->comment_id;
> }
>
> The goal is to cycle through that array and display the
> picture followed
> by the belonging comments:
>
> Picture ID 1
> -Comment 1 to pic_id 1
> -Comment 2 to pic_id 1
> -Comment 3 to pic_id 1
>
> Picture ID 2
> -Comment 1 to pic_id 2
> -Comment 2 to pic_id 2
>
> That does sound easy, but unfortunatelly I could not figure
> it out so far.
>
> Can somebody give me a hint on how to cycle throug the arrays, or an
> alternative way to achive my goal?

Something like this should work:

foreach ($comment_id as $pic_id=>$comment_ids):
echo "Start of information for picture $pic_id";
foreach ($comment_ids as $com_id):
echo "Comment $com_id for picture $pic_id";
endforeach;
endforeach;

Cheers!

Mike

---------------------------------------------------------------------
Mike Ford, Electronic Information Services Adviser,
JG125, The Headingley Library,
James Graham Building, Leeds Metropolitan University,
Headingley Campus, LEEDS, LS6 3QS, United Kingdom
Email: m.ford@leedsmet.ac.uk
Tel: +44 113 812 4730 Fax: +44 113 812 3211


To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm