I am trying to create a database to hold a voting system.
I am beginning to getting the database up and running simply but an struggling on the query.
The tables are like this:
From this I want to create a query (or view) to show the entries, like below:
submissionID question option
001 Colour of sky Blue
002 Colour of Sky Red
003 10 Plus 5 15
004 Colour of Sky Blue
006 10 Plus 5 15
Eventually I will use php to create a graph for each questions.
If someone can help with the query it will get me started!