Ok, and so i am making progress since my last question. My question now is much more simple, or at best I realize more clearly what my real question is. During my AppDelegate I've this code to see in data from the database:

-(void) readFromDatabase {
// Setup the database object
sqlite3 *database;

// Init the Array
sections = [[NSMutableArray alloc] init];

// Open the database from the users filessytem
if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {
    // Setup the SQL Statement and compile it for faster access
    const char *sqlStatement = "select * from books";
    sqlite3_stmt *compiledStatement;
    if(sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL) == SQLITE_OK) {
        // Loop through the results and add them to the feeds array
        while(sqlite3_step(compiledStatement) == SQLITE_ROW) {
            // Read the data from the result row
            NSString *aChapter = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 1)];
            NSString *aSection = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 2)];

            // Create a new object with the data from the database
            Text *text = [[Text alloc] initWithChapter:aChapter verse:aSection];

            // Add the object to the  Array
            [sections addObject:text];

            [text release];
    // Release the compiled statement from memory


Which is working fine. It's reading through in in the books table the values that originated from the 2 posts after my id column (the industry primary key). So in application, the very first value is inhabiting a uitableview, and also to press the row goes towards the detail view in which the value comes from the following column within the db. This really is all fine, but my real question is concerning how to import multiple records at the same time. So during my detail view, I want there to become a uitextview, and I have to in some way change my sql query to something similar to

"select * from books WHERE column = X"

where X will be a set number I'd affect the batch of records I wish to have displayed altogether within the uitextview. Can't I actually do that? Tap into a column that is not always unique, or perhaps a primary key? That batch of records would obviously be connected using the original value within the uitableviewcell. I understand this can be a very easy and simple factor to complete, I simply can't learn how to get it done! Therefore if anybody can understand this and assist me, it might be GREATLY appreciated! Thanks

Edit: Addition

So the issue I'm encountering, (which might be the dwelling of my database or something like that) is the fact that that one query fits all approach just is not doing the work for me personally. During my application, I have to have 1 uitableview that's populated with data from the table during my database, after which yet another tableview that drils lower after that that signifies chapter amounts specific towards the section clicked on on within the first uitablevew, thats also from another table within the database, after which finally a detail view that shows multiple records simultaneously inside a uitextview, everything cope with the chapter selected within the second uitableview, again, from another table within the database. So my problem is the fact that I am not liking this method I've become myself into where Im creating a query saying "choose * and merely obtain the next two values you discoverInch type of a factor. I have to have the ability to make my queryies more specific, and never solely in a single table, but multiple. Does which means that will be able to setup multiple const char *sqlStatement = claims and link them particularly towards the preferred output I want? Should you could just type of show how these pieces fit together, it might be very appreciated. Thanks

alter the above query

const char *sqlStatement = "choose * from books"

such as this

const char *sqlStatement = [[NSString stringWithFormat:@"choose * from books where column=%@",X] UTF8String]

if questions please reply!