title: Pulling data from MySQL into json array
body: <p>I'm trying to pull data from my database using json in php. I have a few elements I need to specific then to post them on a page.</p>
  
  <p>I want to "fetch" the data from mysql and return it to a json_encode. How can I do this using the SELECT method.  Some had used PDO methods and other have used mysql_assoc, which confuses me.</p>
  
  <p>For instance,</p>
  
  <p>I have rows of: 'id' , 'title' , 'start', 'backgroundColor'...etc. along with a default value for all of them. ($array[] = "someValue = default")</p>
  
  <p>I want it to export like so:</p>
  
  <pre><code>array(
        'id' =&gt; 1,
        'title' =&gt; "someTitle",
        'start' =&gt; "2012-04-16",
        'backgroundColor' =&gt; "blue",
        'someValue' = &gt; "default",
        ...
        ),   ....
   ));
  </code></pre>
  
  <p>If anyone could help me with this with the best detail, I'd be awesome!</p>