<OBJECT> Drop Down Menu : Connect to mysql

[CEinNYC]

your MySQL server version:  5.1.36

 

SELECT * FROM game_weapons 

 

Table: Picture Attached

 

the EXPLAIN output for your query, if applicable:

I wish to connect a drop down menu's selection of weapons with the correlated table information.

 

What do I want to happen:

Click on a drop down Menu and have a list of weapons, these weapons are associated with a set number in the database and passed onto the next screen.  (The larger number wins, this part I have figured out).

 

<p>

<select name="weapon2" style="font-size:20px;font-family:Arial;width:275px">

<option value="power">Power</option>

<option value="intelligence">Intelligence</option>

<option value="speed">Speed</option>

<option value="reserve">Reserve</option>

</select>

</p>

 

 

I do have the battle code figured out!  (This should be the last step).

 

 

 

[attachment deleted by admin]