Associate
- Joined
- 15 Jan 2004
- Posts
- 1,463
- Location
- Doncaster
Right, bear with me.
I need to create an SQL database with a HTML/PHP frontend to 'match up' pairs of data.
Considering it's a match up exercise, obviously my variables come in 2 types - 'word/idea' and 'example/definition'.
Now, I'm an English teacher by trade, so this will be something like 'Metaphor' and 'The moon is a balloon'.
I will create a PHP page which calls 10 random 'examples' (from a set of, say, 100) and a HTML form which allows users to match a name for the example (e.g. Metaphor) from a dropdown box. All will then be validated and checked via the use of a button on the form.
My question boils down to: what's the best way to go about doing this? My HTML knowledge is good, but my PHP and SQL knowledge is only at a beginner level, though I am pretty good at following tutorials (managed to build a blog/basic database that way recently).
(I've searched repeatedly for software/code templates to do something similar already, but keep drawing a blank.)
I need to create an SQL database with a HTML/PHP frontend to 'match up' pairs of data.
Considering it's a match up exercise, obviously my variables come in 2 types - 'word/idea' and 'example/definition'.
Now, I'm an English teacher by trade, so this will be something like 'Metaphor' and 'The moon is a balloon'.
I will create a PHP page which calls 10 random 'examples' (from a set of, say, 100) and a HTML form which allows users to match a name for the example (e.g. Metaphor) from a dropdown box. All will then be validated and checked via the use of a button on the form.
My question boils down to: what's the best way to go about doing this? My HTML knowledge is good, but my PHP and SQL knowledge is only at a beginner level, though I am pretty good at following tutorials (managed to build a blog/basic database that way recently).
(I've searched repeatedly for software/code templates to do something similar already, but keep drawing a blank.)