Random information requested from DB

[Nb1320]

Okay, I am still new...

I have a database setup that sends the information to a label and 4 buttons. The buttons are obviously answers to the question displayed in the label. I have everything setup, but I cannot figure out how to make the text random that is sent to the buttons. Each answer has its own ID and the button knows that, but like I said, I want the text sent from the DB to go to random buttons everytime it loads. Thank you!:sign0085:

 

[mc73]

Check this.

 

[Nb1320]

Tried it..

That is actually one of the the threads that got me where I am now. I still need the information coming from the DB to be in random buttons and now I am curious as to how to make sure the same questions are not asked more than once.

 

[mc73]

Have a field for e.g. `asked` and set its value to 1 when the specific question is read. In your random picking query set a 'where `asked`=0, just an example.
About the buttons, though not quite the story here, you can check this.