How to write a Query for listing the results based on some submitter_id + cakephp

Question

Hi,

i am having a Table structure like

Reports id report_id title form_id attribute_id 1 1 r1 24 69 2 1 r1 24 72

   Results 

    id form_id attribute_id value submitter_id
     1    24     69          A      1
     2    24     69          B      2
     3    24     72          C      1
     4    24     72          D      2

i am trying to fetch foreach Report's attribute_id i want to get the entries from the Results table.

where the entries will be listed in the Table after retriving in the Format like

Table

  1st_attributeid   2nd_attribute_id
     A                  B                 - submitter 1
     C                  D                 - submitter 2

i.e. to list each submitters entries for 1st attributeid and for the second attribute_id..

HOw to do so. Please help me..