title: mysql select single column as single dimension array in PHP
body: <p>I'm selecting a single column from my mysql database:</p>
  
  <pre><code>$savedSQL = 'SELECT can_id FROM savedsearches WHERE user_id = "'.mysql_real_escape_string($user_id).'" AND insertTime &gt;= "'.$lastSigTime.'"';
  $savedQuery = mysql_query($savedSQL);
  </code></pre>
  
  <p>And I'd like to return the values as a single dimension, enumerated array such that array[0] = row1, array[1] = row2, etc.</p>
  
  <p>When I put it into an array like this:</p>
  
  <pre><code>while($savedResult = mysql_fetch_array($savedQuery))
      {   $savedArray[] = $savedResult;   }
  </code></pre>
  
  <p>It returns it as a multi-dimension array so that array[0][0] = row1, array[1][0] = row2, etc.</p>
  
  <p>I was thinking of adding something like this:</p>
  
  <pre><code>while($i=0;$i&lt;count($savedArray);$i++)
  {
   $newSavedArray[$i] = $savedArray[$i][0]
  }
  </code></pre>
  
  <p>But is there an easier, more efficient way to accomplish this?</p>