Display data dynamically based on dropdown menu selection

This site is best viewed in a modern browser with JavaScript enabled.

Display data dynamically based on dropdown menu selection

capitan

Hey, need help from some php Ninja's.

I have some members details set-up in a database where a plugin has done the easy part and created a table and id for members. I now need to insert a drop down menu on each members page which will dynamically display their price based on the selected location. So the member id as well as location field/values will need to be taken into consideration.

Thanks in advance.

capitan

So I figured out how to display the column names from the table with

<?php
$dbhost = 'localhost';
$dbname ='database';
$dbuser = 'root';
$dbpass = 'pass';

mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());

<?php
$result = mysql_query("SHOW COLUMNS FROM my_database")
or die(mysql_error());

while($nt=mysql_fetch_row($result)){
echo "<option value=" . $nt[0] . ">" . $nt[0] . "</option>";
}

</select>

How do I select only specific columns, as I only want the ones with location names?