[KaraJ]

Hello,

Does anyone know if it is possible to pull the field names from a MySQL database into a PHP-generated dropdown menu? I know how to pull data from the database into a dropdown menu and then return results based on the user's choice, but I cannot figure out how (or if it is possible) to pull the actual field names into the dropdown menu. Any help would be very much appreciated!

[dennispopel]

http://php.paco.net/manual/en/functi...ist-fields.php

[alabaster_lynch]

Originally Posted by KaraJ

Hello,

Does anyone know if it is possible to pull the field names from a MySQL database into a PHP-generated dropdown menu? I know how to pull data from the database into a dropdown menu and then return results based on the user's choice, but I cannot figure out how (or if it is possible) to pull the actual field names into the dropdown menu. Any help would be very much appreciated!

Yes, this is very possible...I would do something like this

PHP Code:

<?php

mysql_connect('localhost', 'user', 'password');

mysql_select_db('database');

$result = mysql_query('select * from table');

?>

<select name="selectname">

<?php

$i = 0;

while ($i < mysql_num_fields($result)){

  $fieldname = mysql_field_name($result, $i);

  echo '<option value="'.$fieldname.'">'.$fieldname.'</option>';

  $i++;

}

?>

</select>

hope this helps....Jose

[KaraJ]

I just got a chance to try your suggestions and they worked great. Thanks, guys!

Kara

[KaraJ]

I have another question related to this. Hopefully someone can help me with it. Does anyone know how to choose specific field names from a database if you don't know what they are ahead of time? For instance, I have a database with concentrations of various chemical elements that were taken in different years. To avoid a lot of extra rows of data, I gave each element its own field. But, not all elements were tested in each year. I would like people to be able to choose the year they are interested in (there is a year field in the database as well) and, based on that, return a list of elements for which there is data. Then, they can pick only the elements they are interested in from that year and get the actual data. The only sticking point right now is that I don't know how to extract just the element fields that have data in them for the year that was chosen. Help, anyone?

Kara