Need Help With MySQL and PHP

[rpainter]

Hello. I am a newbie, but not afraid to try. I really need some help here.

 

I am trying to create a form that posts to a database, and another page that will display the results.

 

Here is what I need:

 

Form Page:

 

The Form Fields: Name, Judge Status (drop-down with the following selections: Novice, Certified, Senior, Master), Events (these will most likely need to be check boxes, as you can sign up to judge more than 1 event), and obviously the Submit Button.

 

The List Page:

 

This page will need to have a separate table for each event. Each table will need to display the name and status of each judge who signed up for the event.

 

For instance, Bob signs up to judge events 1,2,3. John signs up to judge events 1,3,4. The tables need to look like this:

 

Event 1

Name	Status
Bob	Novice
John	Senior

 

The other events will need to have their own tables.

 

I hope this makes sense, and thanks for your help.

[revraz]

Welcome to the forums.  We try to help others with the code they create rather than create it for them.  So if you post what you have so far, people will usually be eager to help you.

 

Also, most of this has been posted about many times, so you may even want to try searching the forums for Forms and the like and you'll probably get some good examples right away.

[rpainter]

Thanks for the answer, the problem is, I don't even know where to begin. This topic can me marked "Solved" though, as I found a module for the software that i am using.