Hi i'm new to this site and rusty with my databases since i haven't done any in 2 years.
I'm doing this side project and i would like help with the design of the database that i want to work with my website i'm gonna do in php
I'm doing something that when a username log into the website everyone will have a randomized output of all the possible question, every question will only have 1 choice of answer and will give different points depending on the question's difficulty
i already have a username table with all the information i want to gather from the user.
I also have a question table where i have all the possible question and the possibility to add more and since it will be pictures that will be the question i have something for the filename
what i have a hard time to do is to make them work together with the output i want, maybe i'm over thinking it and a little guidance would be really apreciated