Help me with matched data query?

Joseph_Sliker

Hi;

Say I am dealing with three data columns in a MySQL table:

STUDENTID, SEASON, SCORE.

Compliance with the testing has been unreliable, so I don't always have FALL, or WINTER, or SPRING data for each kid.

I want to pull only the data where SCORES do exist for each kid in all three seasons.

Subsequent work with the data can continue from a two-dimensional array $SCOREarray[STUDENTID][SEASON]

The MySQL version I have to work with is 3.23.45, so I don't have the option of doing subqueries.

I would appreciate any suggestions as to how to approach this as I am feeling rather thick-headed this morning.

Thanks.

Joseph_Sliker

Maybe I could run the query by SEASON (for each SEASON value), put each query's result into an array and then merge the arrays? Is there a php Array command that would limit the resulting arrays to the matched records?

Hmmm....

---10 min later---

Like, maybe "array_intersect_key" if I use STUDENTID as the Key, eh?

Joseph_Sliker

Okay, all the data is going in to $SCORE_ARRAY.

When I do a print_r command I get output like:

Array ( [0] => Array ( [ID] => 2026 [SEASON] => AUG-NOV [SCORE] => 163 ) [1] => Array ( [ID] => 2027 [SEASON] => AUG-NOV [SCORE] => 190 ) [2] => Array ( [ID] => 2028 [SEASON] => AUG-NOV [SCORE] => 103 ) [3] => Array ( [ID] => 2029 [SEASON] => AUG-NOV [SCORE] => 72 ) [4] => Array ( [ID] => 2033 [SEASON] => AUG-NOV [SCORE] => 115 ) [5] => Array ( [ID] => 2026 [SEASON] =>DEC-FEB [SCORE] => 100 ) [6] => Array ( [ID] => 2027 [SEASON] => DEC-FEB [SCORE] => 116 ) [7] => Array ( [ID] => 2028 [SEASON] => DEC-FEB [SCORE] => 117 ) [8] => Array ( [ID] => 2039 [SEASON] => DEC-FEB [SCORE] => 159 ) [9] => Array ( [ID] => 2041 [SEASON] => DEC-FEB [SCORE] => 91 ) [10] => Array ( [ID] => 2042 [SEASON] => DEC-FEB [SCORE] => 102 ) [11] => Array ( [ID] => 2043 [SEASON] => MAR-JUN [SCORE] => 101 ) [12] => Array ( [ID] => 2044 [SEASON] => MAR-JUN [SCORE] => 88 ) [13] => Array ( [ID] => 2105 [SEASON] => MAR-JUN [SCORE] => 74 ) [14] => Array ( [ID] => 2026 [SEASON] => MAR-JUN [SCORE] => 123 ) [15] => Array ( [ID] => 2027 [SEASON] => MAR-JUN [SCORE] => 138 ) [16] => Array ( [ID] => 2028 [SEASON] => MAR-JUN [SCORE] => 137 ) )

Is there a simple way to parse this heap of data into $SCORE_ARRAY[SEASON] components that I can feed into the array_intersect_key() function?