iptables -N mysql
iptables -A mysql --src 127.0.0.1 -j ACCEPT
iptables -A mysql --src 1.1.1.1 -j ACCEPT
iptables -A mysql -j DROP
iptables -I INPUT -m tcp -p tcp --dport 3306 -j mysql$result = $mysqli->query("SELECT name FROM users WHERE ref = '$a_name'");
$names =[];
while($row = $result->fetch_array(MYSQLI_NUM)) {
$names[] = "'" . $row[0] . "'";
}
$result->close();
$statref2gets = implode(",", $names);SELECT
r.id,
r.record,
COUNT(c.id) CountOfComments
FROM records r LEFT JOIN
comments c ON r.id = c.record_id
GROUP BY r.id