Dropdown menu + query in game

[Corpheous]

I have a simple dropdown menu that is generated using a database (the content of it). I'd like to be able to select one of the things in the database and have it display the results of a query (that's already done) in PHP.

Alternatively, I originally was looking to generate some type of link or something that when clicked could select a value so that I could do the same thing as above.

Basically it's an Armor Shop for a practice game in PHP I'm making. The lists are for armor, the database containing names, price, and armor class.

Help is greatly appreciated 🙂

[WinterDragon]

grins I specialize in making RPGs (browser based) in PHP/MySql.

so lets say you have some links they go like this..

Buy Boots
Buy Shields
Buy Platemail

(each one looking like: game.php?boots although later you could change it up)

$query = $QUERY_STRING;

#Here is the connection process, I won't put it in there, you should know at least how to do that :)

$listQuery = "SELECT name, price, ac FROM armorTable WHERE type='$query'";

while($list = mysql_db_query("database", $listQuery)) {
echo "$list[name] --- $list[ac] --- $list[price]<Br>";
}

Perfect! well you can make it pretty if you want, at any rate, that just gives you basic jest of it eh? ASK MORE QUESTIONS if you want 🙂