title: How to randomly set text to four buttons from SQLite db?
body: <p>I have a SQLite table imported in assets, trial one with 10 rows and 6 columns (_ID, QUESTION, ANSWER, OPTION1, OPTION2 AND OPTION3). I managed to read random row from database and assign that data, one question to a textview, and four possible answers to my buttons  with this code:</p>
  
  <pre><code>TestAdapter mDbHelper = new TestAdapter(this);
          mDbHelper.createDatabase();
  
          mDbHelper.open();
  
          final Cursor c = mDbHelper.getTestData();
  
          question.setText(c.getString(1));
          bOdgovor1.setText(c.getString(2));
          bOdgovor2.setText(c.getString(3));
          bOdgovor3.setText(c.getString(4));
          bOdgovor4.setText(c.getString(5));
  </code></pre>
  
  <p>I also have this line in my TestAdapter class:</p>
  
  <pre><code>String sql ="SELECT * FROM tblPitanja ORDER BY RANDOM() LIMIT 1";
  </code></pre>
  
  <p>This is all good, but I wont randomly to assign questions to buttons, cause this way every time the answer is at button 1. How to  mix questions between  my buttons?</p>