EBAQn1Yu

1MainData helper = new MainData(this);name
2    SQLiteDatabase db = helper.getWritableDatabase();        
3
4String uid = MessageRecieverId;
5    int userData = 0;
6    Cursor data2 = helper.getUserData();
7    while (data2.moveToNext()) {
8        userData = data2.getInt(data2.getColumnIndex(KEY_MESSAGES_SENT));
9    }
10    ContentValues contentValues2 = new ContentValues();
11    contentValues2.put(KEY_ID, uid);
12    contentValues2.put(KEY_MESSAGES_SENT, userData+1);
13    long returnVariable2 = db.update(TABLE_USER_DATA, contentValues2,null,null);
14    if (returnVariable2 == -1) {
15        Toast.makeText(getApplication(), "Nope", Toast.LENGTH_LONG).show();
16        //-1 means there was an error updating the values
17    } else {
18        Toast.makeText(getApplication(),"uf", Toast.LENGTH_SHORT).show();
19    }
20}
21	
22String userQuery = "CREATE TABLE IF NOT EXISTS " + TABLE_USER_DATA + "(" + KEY_ID + " TEXT, " + KEY_NAME
23            + " TEXT, " + KEY_MESSAGES_SENT + " INTEGER, " + KEY_MESSAGES_RECIEVED + " INTEGER, "
24            + KEY_MESSAGES + " INTEGER, " + KEY_TIME_SPENT + " TEXT)";
25	
26public Cursor getUserData() {
27    SQLiteDatabase db = this.getWritableDatabase();
28    String query = "SELECT * FROM " + TABLE_USER_DATA;
29    return db.rawQuery(query, null);
30}