Quote (carteblanche @ Mar 15 2016 08:57pm)
if i was a real developer who knew anything, i wouldn't be trolling gaming forums.
and i didnt follow you when you suggested dynamically creating tables. can't you just have three columns? input, word, nextword. it's a very linked-list kind of structure though
Each input needs to be attached to multiple linked lists if you think of it like that.
Code
input => [["this", "is", "a", "text"], ["woah", "another", "test"]]
Table would look something like
Code
Table Inputs (question Text, Linked_Lists as Text)
Table Linked_List_For_Answer1(start_word as Integer, word as Text, next_word as Text)
Data for an Input would be something like
Code
>select linked_lists from Inputs where question like "Hello %";
"Linked_List_For_Answer1"
>select word, next_word from Linked_List_For_Answer1 where start_word = 1 order by random();
"This", "is"
>select word, next_word from Linked_List_For_Answer1 where word = "is" order by random();
"is", "a"
Basically for each unique question input there needs to be a way to segregate multiple linked lists that belong to that input.
I could potentially add a input column and match something like
Code
select word, next_word from inputs where input = "Hello %"...
But multiple unique tables for each input seems like a better way to organize it.