<?php
$servername = "xxx";
$username = "moath";
$password = "xxxx";
$dbname = "moath";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}else{
}

$sql = "SELECT COUNT( 'proxytable' ) AS  `proxy` ,  `proxy`
FROM  `proxytable`
GROUP BY  `proxy`
ORDER BY  `proxy`
LIMIT 1";


$result = $conn->query($sql);
if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
              //echo $row['proxy'];
				//echo "<a href='".$row['proxy']."'>".$row['proxy']."</a>";
			  $ppp = $row['proxy'];
			  $sqldel = "DELETE FROM `proxytable` WHERE `proxy` = '" . $ppp ."'";
			  echo "<a target=_blank href='".$ppp."'>Get Proxy</a>";
			  $resultdel = $conn->query($sqldel);
			  exit();
$conn->close();
die();

    }
    echo "</table>";

} else {
    echo "Out Of Stock <br> Please Contact @imopvp";
}

?>