title: Combining multiple row meta info from MYSQL database to one response
body: <p>I'm working with an existing database and I have a question I know you SQL guys can nail. I have 2 tables, on has an item id and a description, the other stores all the meta for said items. </p>
  
  <p>my two tables are like this....</p>
  
  <pre><code>items- 
  ----------------
  id | description
  ----------------
  
  itemsmeta-
  -----------------------------------------
  itemmeta_id | item_id | fieldkey | value
  -----------------------------------------
  </code></pre>
  
  <p>What I need to do is get a single response, hopefully as an object or array based on a given item ID. So i'd like to say get all meta info based on specific item id. </p>
  
  <p>If I do something like this...</p>
  
  <pre><code>SELECT * FROM items LEFT JOIN itemsmeta ON itemsmeta.item_id = items.id WHERE items.id = 1
  </code></pre>
  
  <p>it returns about 9 rows, one for each meta entry for item number one. Is it possible to structure my query to return one response? </p>
  
  <p>Maybe something like:</p>
  
  <p>Array( [0] => stdClass Object ( [ID] => 1 [Name] => Blah Blah [Meta 1] => Blah Blah [Meta 2] => Blah Blah) ) and so on?</p>