combobox.php
<?php
include_once('db.php');
?>
<div style="width:50px;height: auto; float: left; "> States:</div>
<div align="left" style="width:210px;height: auto; float: left; ">
<select name="states" onChange="getCities(this.value)">
<?php
$result = mysql_query("SELECT * FROM states");
while($row=mysql_fetch_array($result))
{
echo "<option value=".$row[id].">$row[states]</option>";
}
?>
</select>
</div>
database :
table name : states
table id : id
table Name : states
states
----------------------------
id | states
1 | Andra
2 | Tamil Nadu
3 | Pondicherry
db.php
<?php
$mysql_hostname = "localhost";
$mysql_user = "test";
$mysql_password = "BJx3p2awbuTvdVwS";
$mysql_database = "test";
$prefix = "";
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database");
mysql_select_db($mysql_database, $bd) or die("Could not select database");
?>
No comments:
Post a Comment