1

I'm trying to make a simple quiz app. I need to make the question to pop out in random order. Now, I have no problem with working the layout and button, the concept of this little quiz is also familiar to me because I have done it in VB with MySQL, I'm just too unfamiliar with working with sqlite. Now, my question is : 1. Can I create an Android app with MySql? 2. If I can't, how can I make/code a sqlite database with fields like this:

ID | Question | OptionA | OptionB | RightQuestion

I will match the string in RightQuestion to the radio button id to validate each answer the user clicked.

I have read this, this and this, but none of them is what I'm looking for. I need for some help

Community
  • 1
  • 1
user2320275
  • 21
  • 2
  • This question discusses using a mySQL database to hold your official list of questions and how to sync it with a local sqlLite database on the device. Might be helpful: http://stackoverflow.com/questions/6511402/how-to-sync-sqlite-database-on-android-phone-with-mysql-database-on-server – Kyle Apr 25 '13 at 15:50
  • Actually I would like to keep it offline on my first try because I'm not really familiar with this yet – user2320275 May 09 '13 at 14:10

1 Answers1

1

From my point of view, you can use mysql via a web server, which you can send request to the sever and the server will interactive with mysql.

On the other hand, just refer to here for sqlite programming in Android Using the Android SQLite Database

Weibo
  • 1,042
  • 8
  • 18