storing db contents in array PHP

[dmurphy]

I am not sure how to do this, but if it can be done can anyone please help me in this.Basically I have 3 columns in my table:\[code\]ID Set Result Case 1 Set1 PASS 101 2 Set2 FAIL 102 3 Set2 FAIL 101 4 Set1 FAIL 101 5 Set1 PASS 104 $set = $row['Set'];\[/code\]What I am trying to achieve is , foreach of these \[code\]Set\[/code\], store its associated \[code\]Result\[/code\] and \[code\]Case\[/code\] in an array.