mercredi 20 mai 2015

where clause in Mysqlite Android

I am a newbie to in android development .I am working on a workout app .and need to fetch workout's name and description from Mysqlite database .My current Status :-- database -- workout_db tables--chest,back,biceps.... entries in chest tables -- 4(currently)

I am only able to access the first entry of table and other entries are inaccessible . I want to use where cluse and select the exercise name for example -- "Name = xyz"

        c=myDbHelper.query("chest", null, null, null, null,null, null);

        Toast.makeText(exercise.this, Integer.toString(c.getCount()) ,Toast.LENGTH_LONG).show();

It is giving 1 as the output where entries in tables are around 4-5

       c=myDbHelper.query("chest", null, "Name = xyz", null, null,null, null);

is always giving entry as output

Aucun commentaire:

Enregistrer un commentaire