searching and selecting values in an array

Prine

Please see post #4

Thanks 🙂

NogDog

My first instinct is to let MySQL do the work. But to suggest any specifics we'd need some details on the tables involved and exactly what you are trying to accomplish functionally.

Prine

hi, heres a screen grab of the 2 results

http://boxbagz.com/beleh/tables.jpg

I want to loop trough the array and produce the following

collection_month_id, style_id (could be as many as 5 style_id)

eg:

6-06-a_BK_WF_PYP

6-06-a is the collection_month_id

BK
WF
PYP refer to the style_id of that particular month_id

makes sense?

Prine

ok take a look at this result returned from a MySQL query

6-06-a BK

6-06-a WF

6-06-a PYP

6-06-b WF

6-06-c MN

6-06-c WF

6-06-c PYM

6-06-c PYM

These are ID i need to display the relevent images and links on a page

However, i DONT want the month_id (6-06-n) to repeat. I need the style_id (WF, PYP, etc) to be displayed in one string.

eg:

6-06-a has 3 style_id attached to it (according to the results)

so i need the reuslt to be formated in PHP to produce the following

6-06-aBKWFPYP

6-06-bWF

etc..

sorry about the poor explanation.

Here is the code used to fetch the above results:

for( $i=0; $i<$num_results2; $i++ )
{
$style = mysql_fetch_array($result2);
echo "<p><b>".$style['collection_month_id']."</b>\n";
echo "<b>".$style['style_id']."</b>";


}

Prine

ok got it to work by doing the following!

while ($row=mysql_fetch_array($result2)){

 $curr_date=$row['collection_month_id'];

   if ($curr_date==$old_date)
         {
		 $html_string.=$row['style_id'];
}
 	else
         {$old_date=$curr_date; 
          $html_string.="</p><p>".$curr_date."".$row['style_id'];
          }
}
echo $html_string;