// Get the phrases and titles
public static QuizQuestion getTitles(String qry) {
QuizQuestion qq = new QuizQuestion(null, null, null);
ArrayList<Integer> id = new ArrayList<Integer>();
ArrayList<String> phrase = new ArrayList<String>();
List<String> title = new ArrayList<String>();
myDb = getDatabase();
Cursor results = myDb.rawQuery(qry, null);
if (results.getCount() > 0) {
int i = 0;
while (results.moveToNext()) {
id.add(i, results.getInt(0));
phrase.add(i, results.getString(1));
title.add(i, results.getString(2));
i++;
}
}
qq.set_id(id);
qq.setPhrase(phrase);
qq.setTitle(title);
results.close();
return qq;
}
