Code:
<?php
$con = mysql_connect("localhost","username","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db("database",$con);
$sql = "SELECT * from table WHERE mobile='11111111111'";
$result = mysql_query($sql,$con);
//print_r(mysql_fetch_array($result));
$info= mysql_fetch_array($result);
echo $info[1];
mysql_close($con);
?>