What is the best loop to use

[droopsnoot]

I use PDO, so the method is a little different, but if you scroll down this forum for a few topics you’ll find plenty of code that uses the technique.

ETA: here you go, from a couple of threads down:

@rpkamp

Also, that query should be prepared to prevent SQL Injection:

$statement = $mysqli->prepare('SELECT ip FROM `unbanned` WHERE ip=?');
$statement->bind_param("s", $ip);
$stmt->bind_result($selectedIp);
$stmt->fetch();

if (null !== $selectedIp) {
    echo 'Wow you have permission to enter!';
}