title: php mysql advanced selecting
body: <p>table 1  = events -> holds a list of events</p>
  
  <p>table 2  = response -> holds a list of users responses has a foreign key of eid which corresponds with events table</p>
  
  <p>I need to join the tables together so it can return an array similar to this on php.</p>
  
  <pre><code>array(
    0 =&gt; array(
        'title' =&gt;'',                      //title of events table
        'contents' =&gt;'this is a demo',     //contents of events table
        'users' =&gt; array(                  //users comes from response table
             0 = array(
               'firstname'=&gt;'John',
             ),
             1 = array(
               'firstname'=&gt;'James',
             )
        )
    )
  );
  </code></pre>
  
  <p>can this be done? using mysql only? coz i know you can do it on php.</p>