Php > Database Related sample source codes

Populate dropdown box with MySQL table fields

Populate dropdown box with MySQL table fields

<? 
$connection = mysql_connect("localhost","user","pass"); 
$fields = mysql_list_fields("dbname", "table", $connection); 
$columns = mysql_num_fields($fields); 
echo "<form action=page_to_post_to.php method=POST><select name=Field>"; 
for ($i = 0; $i < $columns; $i++) { 
echo "<option value=$i>"; 
echo mysql_field_name($fields, $i); 
} 
echo "</select></form>"; 
?>

Privacy Policy | Link to Us | Links