sqlite - Android SQLiteDatabase query with WHERE clause -
i have sqlitedatabase called "database". in there table called "pics". in table there 3 columns follows, drawablename text,drawablereference integer,picturerating real. want query database integer expect in drawablereference column. want can corresponding drawablename , picturerating same row. wrong query? public class edititemactivity extends activity { edittext textfield=null; ratingbar ratingbar=null; sqlitedatabase db=null; cursor dbcursor=null; @override protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); intent intent=getintent(); integer imageid=intent.getintextra("imageid",-1); if(imageid==-1){ return; } string id=imageid.tostring(); //not used right setcontentview(r.layout.edit_item_layout); db=this.openorcreatedatabase("database",this.mode_private,null); string selection="drawableref...