document.write('\n'); document.write('\n'); document.write('\n'); document.write('\n'); document.write('
\n'); document.write('
\n'); document.write(' \n'); document.write(' \n'); document.write(' \n'); document.write(' \n'); document.write(' \n'); document.write('
1\n'); document.write('2\n'); document.write('3\n'); document.write('4\n'); document.write('5\n'); document.write('6\n'); document.write('7\n'); document.write('8\n'); document.write('9\n'); document.write('10\n'); document.write('
EGODatabase* database = [EGODatabase databaseWithPath:[NSHomeDirectory() stringByAppendingPathComponent:@"Documents/database.db"]];\n');
document.write('EGODatabaseResult* result = [database executeQuery:@"SELECT * FROM `posts` WHERE `post_user_id` = ?", [NSNumber numberWithInt:10]];\n');
document.write('for(EGODatabaseRow* row in result) {\n');
document.write('	NSLog(@"Subject: %@", [row stringForColumn:@"post_subject"]);\n');
document.write('	NSLog(@"Date: %@", [row dateForColumn:@"post_date"]);\n');
document.write('	NSLog(@"Views: %d", [row intForColumn:@"post_views"]);\n');
document.write('	NSLog(@"Message: %@", [row stringForColumn:@"post_message"]);\n');
document.write('}\n');
document.write('
\n'); document.write('
\n'); document.write('
\n'); document.write('
\n'); document.write(' via Snippie [a104ecc4]Original\n'); document.write('
\n'); document.write('
\n'); document.write('\n'); document.write('
');