# Get more than one value from database **URL:** https://community.thunkable.com/t/get-more-than-one-value-from-database/2670337 **Category:** Questions about Thunkable X **Tags:** beginner **Created:** [October 29, 2023, 10:32pm UTC](https://community.thunkable.com/t/get-more-than-one-value-from-database/2670337 "2023-10-29T22:32:46Z") **Posts on this page:** 8 **Page:** 1
### Author: ![650014mw4](https://avatars.discourse-cdn.com/v4/letter/6/71e660/32.png) [@650014mw4](https://community.thunkable.com/u/650014mw4) #### Post date: [October 29, 2023, 10:32pm UTC](https://community.thunkable.com/t/get-more-than-one-value-from-database/2670337/1 "2023-10-29T22:32:46Z")
Hello everyone, so when I get more than one value, it doesn’t show up. I want to construct a game with four different options, however, there are always empty options or, worse, the same option repeated multiple times. ![Screenshot 2023-10-29 222734](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/9/1994a4ed53adf911a62bd2b1574c6b46e5bc7f97.png) ![Screenshot 2023-10-29 222746](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/d/9da78152e801d0abfe8697b1da053fd2f94a9b24.png) ---
### Author: ![650014mw4](https://avatars.discourse-cdn.com/v4/letter/6/71e660/32.png) [@650014mw4](https://community.thunkable.com/u/650014mw4) #### Post date: [October 29, 2023, 10:33pm UTC](https://community.thunkable.com/t/get-more-than-one-value-from-database/2670337/2 "2023-10-29T22:33:48Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/9/392cc570e66e86c19b70cff278b6e267e472f464.png) ---
### Author: ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14) #### Post date: [October 30, 2023, 4:34am UTC](https://community.thunkable.com/t/get-more-than-one-value-from-database/2670337/3 "2023-10-30T04:34:23Z")
Hello, @650014mw4! Welcome to our Community! First thing I’d like to point out here is, the variable `Result` is a value/string variable, whereas the variable `List options` is a list. In your while loop, you are setting the options list variable (which is a list) to a value from your table which is string. Also, the if statement has a condition which is comparing the list variable and the value / string variable. Please share some more insight on what your Options values are stored as, and what your general idea is regarding this app so we can understand the issue better. Thanks! ---
### Author: ![650014mw4](https://avatars.discourse-cdn.com/v4/letter/6/71e660/32.png) [@650014mw4](https://community.thunkable.com/u/650014mw4) #### Post date: [October 30, 2023, 3:14pm UTC](https://community.thunkable.com/t/get-more-than-one-value-from-database/2670337/4 "2023-10-30T15:14:46Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/1/f1f9652003ffc960beda72e8ff946a75a1397496.png) I have roughly 300 possible answers in the database and I’m attempting to make a game with different levels. For example, one of the levels guess the symbol, for example 1? 1 = 2 so what is the missing symbol and the flowing level will be like 1 + 1 =? So you have to guess the answer here, so I’m going to give them four alternatives. When I try to make the correct number show there with the other three random numbers, I either make all the options empty with only the correct answer or it keeps repeating the same number. Thank you for your assistance. ---
### Author: ![tthompson41231](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tthompson41231/32/161401_2.png) [@tthompson41231](https://community.thunkable.com/u/tthompson41231) #### Post date: [October 30, 2023, 4:56pm UTC](https://community.thunkable.com/t/get-more-than-one-value-from-database/2670337/5 "2023-10-30T16:56:15Z")
I made a quick example for you to follow and it doesn’t require a database. In this example I am only doing addition and subtraction. [https://x.thunkable.com/copy/5611bbd22ea9997971a24f56e7b2b5b5](https://x.thunkable.com/copy/5611bbd22ea9997971a24f56e7b2b5b5) ---
### Author: ![650014mw4](https://avatars.discourse-cdn.com/v4/letter/6/71e660/32.png) [@650014mw4](https://community.thunkable.com/u/650014mw4) #### Post date: [October 30, 2023, 8:19pm UTC](https://community.thunkable.com/t/get-more-than-one-value-from-database/2670337/6 "2023-10-30T20:19:23Z")
Thank you for your time and work. But I need to solve mine since it’s a college project: a game for youngsters aged 9 to 12, with all potential responses ranging from 1 to 12. I couldn’t see the blocks if you could send to me a picture I will be thankful I am still learning how to use Thunkable effectively. Thank you ---
### Author: ![tthompson41231](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tthompson41231/32/161401_2.png) [@tthompson41231](https://community.thunkable.com/u/tthompson41231) #### Post date: [October 30, 2023, 11:07pm UTC](https://community.thunkable.com/t/get-more-than-one-value-from-database/2670337/7 "2023-10-30T23:07:46Z")
![example](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/8/98102c1532f770fd01ecb6f11ea2891ad644ff6c.png) ---
### Author: ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system) #### Post date: [January 28, 2024, 11:08pm UTC](https://community.thunkable.com/t/get-more-than-one-value-from-database/2670337/8 "2024-01-28T23:08:37Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.