title: C: Iterate through SQLite records and assigning each value to a variable
body: <p>I have table USER with columns ID, NAME and ADDRESS. e.g.</p>
  
  <p>Column ID has 1,2
  Column NAME has Bob, Jane
  Column ADDRESS has UK, US</p>
  
  <p>And I wish to iterate through all records and save each column into an array. The result would be something like this:</p>
  
  <p>char *NAME[2];
  NAME[0] would have "Bob", NAME[1] would have "Jane" and</p>
  
  <p>char *ADDRESS[2];
  ADDRESS[0] would have "UK", ADDRESS[1] would have "US". </p>
  
  <p>Can someone point me in the right direction instead of calling an SQL statement for each array entry?</p>
  
  <p>Thanks in advance!</p>