MySQL Results + Secondary results

dbrown

Hey everyone,

I'm pulling results from a database in a fairly standard way.

Obviously this isn't exact, it's just to give you an idea how I'm making the call just in case it matters.

$query = "Select * FROM <table> WHERE <criteria>";
$result = mysql_query($query)
$numofrows = mysql_num_rows($result);
for ($i=0; $i < $numofrows; $i++){
$var = mysql_result ($result, $i, "col name");

// Display looped results
}

All this gets me nifty results row by row of course. And I print those results to the screen.

What I need to do, is then take the entire page of results (not the individual rows) and generate secondary results from it.

In my case, if -

Row 1 results has A and B
Row 2 results has B and C
Row 3 results has A and D

I need say if A and D (from row 1 and 3) is present then print that X is available.

I haven't been able to find a way to handle the secondary results. Can anyone point me in the right direction?

Thanks for reading!

bretticus

I 'm not exactly sure what you are trying to accomplish. I or someone else might be able to help you further if you can be more specific. However...based on what I can surmise, you could store occurrences of A,B,C,D, etc. in an array as you loop through your results. An example might be:

<?php
$holder = array();
$query = "Select * FROM <table> WHERE <criteria>";
$result = mysql_query($query)
while($row=mysql_fetch_row($result)) {
       $holder[$row[0]]++;
       if ( array_key_exists('A', $holder) && array_key_exists('D', $holder) ) {
           //print X is available.
      }
}
?>

Of course that code is based on assumption only, but maybe it can point you on the right direction at least.

dbrown

You rock Bretticus, many thanks!

You certainly got me pointed in the right direction, and it works 🙂