[Syncronising PHP to MySQL]

Hi.

 

I have a table saved in MySQL

The name of the table is 'tournaments'.

One of the fields in this table is 'tournament_name'.

There are 10 tournaments within this table.

 

I also have a Expression Web 4 form where users enter a their names, addresses etc and select which tournament they want to play in from a dropdown dox.

 

Mu question is this. What PHP code do I use to let users choose from the 10 tournaments? The dropdown box from the form needs to be linked to the right table, then the right field; HOW do I do this??

 

Thanks

Kevin