Fetch data from sqlite

gistfile1.txt

-(NSMutableArray *) getChapters{
	sqlite3 *database = Pc2MacDatabase();
	
	NSMutableArray *chapters = [[[NSMutableArray alloc] init] autorelease];
	
	NSString *nsquery = [[NSString alloc] initWithFormat:@"SELECT * FROM CHAPTER ORDER BY ID"];
	const char *query = [nsquery UTF8String];
	[nsquery release];
	
	sqlite3_stmt *statement; 
	int prepareCode = (sqlite3_prepare_v2( database, query, -1, &statement, NULL));
	if(prepareCode == SQLITE_OK) {
		while (sqlite3_step(statement) == SQLITE_ROW) {
			Chapter *newChapter= [[Chapter alloc] init];
			newChapter.chapterNumber = sqlite3_column_int(statement, 0);
			newChapter.chapterName = [NSString stringWithCString:(char *)sqlite3_column_text(statement, 1) encoding:NSUTF8StringEncoding];
			newChapter.isFree = sqlite3_column_int(statement, 2);
			[chapters addObject:newChapter];
			[newChapter release];
		}
		sqlite3_finalize(statement);
	}
	
	return chapters;
}