将DropDown值插入MYSQL

Question

This is my html form and php file i have to insert my budget dropdown values by select into database i have to select values from budget and selected value can insert in database and my data is inserting in my database when i click twice on submit button

<form action="insert.php" method="post" id="register-form" onsubmit=" return add();">
    <div class="label"> Name</div><input type="text" id="name" name="name" /><br />
    <div class="label">Email</div><input type="text" id="email" name="email" /><br />
    <div class="label">Phone Number</div><input type="text" id="phone" name="phone" /><br />
    <div class="label">budget</div>
    <select id="budget" name="budget">
        <option value="">select</option>
        <option value="1">0-100</option> <!-- first option contains value="" -->
        <option value="2">100-200</option> 
        <option value="3">200-300</option> 
    </select>
    <br /><br />
    <input type="submit"  onclick="add()" name="submit" />
    <div id="message"></div>
</form>

insert.php

<?php
    include("config.php");
    if(isset($_POST['submit'])){
       $name=$_POST["name"];
       $email=$_POST["email"];
       $phone=$_POST["phone"];
       $budget=$_POST["budget"];
       $insert_query="insert into form(name,email,phone,budget) values ('$name','$email','$phone','$budget')";
       $con=mysql_query($insert_query);
    }

?>

Answer 1

dropdown pass option value in variable so change the option value which you want to insert in database

<select id="budget" name="budget">
            <option value="">select</option>
            <option value="0-100">0-100</option> <!-- first option contains value="" -->
            <option value="100-200">100-200</option> 
            <option value="200-300">200-300</option> 
        </select>