// 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; }