SQLite Android Question.

[jaydac12]

How do I fetch a single value from a row in SQLite? for example I have the method getLevel() and a row with "id, coin, level" and the getLevel() is used to get and return the levelonly. How can i do that? Here's my code.

public int getLevel(int id) {
		int level = 0;
        String selectQuery = "SELECT "+colCurrentLvl+" FROM " + userTable + " WHERE " +userID + "="+id; 
 
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery(selectQuery, null);
 
        if (null != cursor && cursor.moveToFirst()) {
            level = Integer.parseInt(cursor.getString(cursor.getColumnIndex(colCurrentLvl)));
        }
 
        cursor.close();
	    db.close();
 
        return level;
	}

And in my Main Class i need to set it like this.

int level = db.getLevel(1);

but my emulator force closes. Any help?

[jaydac12]

Hello?