Only select admins

Hello, I got an issue with with php + mysql.
I am trying to make a page where it shows the online admins. But right now, it selects all the users.
How do I change it so it only chooses players that has AdminLevel set to 1 or higher?
[php]<?php session_start();

$con=mysqli_connect(“localhost”,“root”,“DELETED”,“DELETED”);
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,“SELECT * FROM playerdata”);

while($row = mysqli_fetch_array($result))
{
echo $row[‘username’] . " " . $row[‘online_ig’];
echo “
”;
}

mysqli_close($con);
?>[/php]

SELECT * FROM playerdata WHERE AdminLevel > 1

Oh it was that simple ^^ Thanks alot

Sponsor our Newsletter | Privacy Policy | Terms of Service