query($sql);
$data = $rows->fetch_assoc();
if($data['TOTAL'] > 0)
{
echo "Email Alrady Exists";
$con->close();
exit;
}
//check mobile number Exists or not
$sql = "SELECT COUNT(`user`.`mono`) AS 'TOTAL' FROM `user` WHERE `user`.`mono` = '".$mo_no."'";
$rows = $con->query($sql);
$data = $rows->fetch_assoc();
if($data['TOTAL'] > 0)
{
echo "Mobile Number Alrady Exist";
$con->close();
exit;
}
//Insert Logic
$sql = "INSERT INTO `user` (`uid`, `name`, `email`, `mono`, `pwd`) VALUES (NULL, '$fname', '$email', '$mo_no', '$pass')";
if($con->query($sql) == TRUE)
{
/* $sql = "SELECT `user`.`uid` AS 'ID' FROM `user` WHERE `user`.`email` = '$email'";
$rows = $con->query($sql);
$data = $rows->fetch_assoc();
echo $data['ID'];*/
echo "CREATED";
$con->close();
exit;
}
else
{
echo "ERROR";
$co