I am working on creating a script that users can utilize for organizing a competition schedule. Each day there are six competitions around the country. Each person has to pick which competitions they will be going to.
I have created a database that holds the competition data. Here is a screenie from a portion of it:

The form I am creating for members, so far, looks like this:

Each day's dropdown lists those six competition locations from that day, as well as the default "None" which you saw in the screenshot. Here is a snippet of the code I am using to create this:

As you can see, I am having to repeat the section of code while changing the date and making variations of the $complist variable. I have been struggling to create a loop where I would not have to keep repeating the same section of code. I am still learning PHP, so don't point and laugh too hard. 😉
Any heroes out there? 😃
To show you I really AM trying, I did manage to work out a script that lists all Drum Corps in the database:
http://www.drumlines.org/threads/showcorps.php