title: PDO fetchColumn() and fetchObject() which is better and proper usage
body: <p>It's been bugging me, I have a query which returns a <strong>single row</strong> and I need to get their corresponding column value.</p>
  
  <pre><code>//Retrieve Ticket Information to Database
  $r = db_query("SELECT title, description, terms_cond, image, social_status, sched_stat FROM giveaway_table WHERE ticket_id = :ticket_id",
      array(
          ':ticket_id' =&gt; $ticket_id
  ));
  </code></pre>
  
  <p>There are two ways that I can get data which is, by using <strong>fetchColumn()</strong> and <strong>fetchObject()</strong></p>
  
  <p><strong>fetchObject()</strong></p>
  
  <pre><code>$object = $r-&gt;fetchObject();
  
  $ticket_info[] = $object-&gt;title;
  $ticket_info[] = $object-&gt;description;
  $ticket_info[] = $object-&gt;terms_cond;
  $ticket_info[] = $object-&gt;image;
  $ticket_info[] = $object-&gt;social_status;
  $ticket_info[] = $object-&gt;sched_stat;
  </code></pre>
  
  <p><strong>fetchColumn()</strong></p>
  
  <pre><code>$title = $r-&gt;fetchColumn() //Returns title column value
  $description = $r-&gt;fetchColumn(1) //Returns description column value
  </code></pre>
  
  <p>Was wondering, which one is better, or are there any pros and cons about this stuff?</p>
  
  <p><strong>if possible,</strong> can you guys also suggest the <strong>best</strong> way (if there's any) on how to retrieve all columns that's been selected in a query and store it into an array with less line of code.</p>