[insert_php]
$con = mysql_connect(“localhost”,”parth”,”ftp2015,,,”);

if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}
mysql_select_db(“parth_admin”, $con);

$query = “SELECT DISTINCT (
District
) AS District, ID
FROM `District_Master`”;
$comments = mysql_query($query);
//$var=array();
//$did=array();
echo’

‘;
echo’

‘;
}
echo’

“;
}
[/insert_php]

[insert_php]
if(isset($_POST[‘search1’]))
{

$selected_Dist = $_POST[‘Dist’];
$selected_Teh = $_POST[‘Teh’];
$selected_City = $_POST[‘City1’];
$selected_add = $_POST[‘address’];
//echo “District— $selected_Dist “;
//echo “Tehsil — $selected_Teh “;
//echo “City-$selected_City”;
$querySearch=”
SELECT * FROM `ITGK_List` WHERE City='”.$selected_City.”‘ and Address like ‘%’ ‘” .$selected_add. “‘ ‘%'”;

$commentsSearch = mysql_query($querySearch);
echo ”

$City

“;
while($rowSearch = mysql_fetch_array($commentsSearch , MYSQL_ASSOC))
{
$cname = htmlspecialchars($rowSearch[‘Name’],ENT_QUOTES);
$District= htmlspecialchars($rowSearch [‘District’],ENT_QUOTES);
$tehsil= htmlspecialchars($rowSearch[‘Tehsil’],ENT_QUOTES);
$City= htmlspecialchars($rowSearch[‘City’],ENT_QUOTES);
$address= htmlspecialchars($rowSearch[‘Address’],ENT_QUOTES);

echo ”

“;
}
mysql_close($con);

[/insert_php]