title: How do I retrieve all the rows from an SQLite table?
body: <p>hello guys i am doing some database operations in iphone .. please can anyone explain me how to retrieve all rows from the table..here in this example it retreives only the latest entered data..</p>
  
  <pre><code>while(sqlite3_step(statement) == SQLITE_ROW)
      {   
          char *field1 = (char *) sqlite3_column_text(statement,0);
          NSString *field1Str = [[NSString alloc] initWithUTF8String: field1];
          char *field2 = (char *) sqlite3_column_text(statement,1);
          NSString *field2Str = [[NSString    alloc] initWithUTF8String: field2];
  
          NSString *str = [[NSString alloc] initWithFormat:@"%@::%@",field1Str, field2Str];
          textv.text=str;
  
          [field1Str release];
          [field2Str release];
      }
  </code></pre>