title: SQlite query - How do I retrieve multiple column data?
body: <p>I'm having great difficulty to find a working example on the net regarding getting multiple values from a SQlite DB using xcode and cocos2dx. Here is the sql query I have:</p>
  
  <pre><code>char sql_query[100];
  sprintf(sql_query, "SELECT * FROM SQList WHERE ColumnD BETWEEN %d AND %d ORDER BY RANDOM() LIMIT 1", MinColumnD, MaxColumnD);
  </code></pre>
  
  <p>The query it self seems to work, the main problem is how do I get the values that I collect from 'select *' into another int or char parameter so that I can use it?</p>
  
  <p>Some example I found referred to using a callback to a struct or mentioned about using sqlite3_prepare_v2 and the step method.</p>
  
  <p>I'm unable to find an example for either methods though, please help!</p>