Get value selected from drop down list in where clause using php code
<p>My code is like this:</p>

<pre><code>$zone = $_POST['zone'];
$state = $_POST['state'];

$sql = "Select zone_id from tbl_zone where zone_name = $zone";
$query = mysql_query($sql);
</code></pre>

<p>I am selecting zone name which is fetched from database and listed in drop down list.
Now i want to get id of zone name to store in other table.</p>

<p>In where clause zone_name is blank.
What changes should be done in above code?</p>

<p>Thanks in advance..</p>
