Only select admins

[BizzyD]

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?

 

Code.

<?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 "<br>";
	}

mysqli_close($con);
?>

[requinix]

Put that restriction into your query.

[BizzyD]

I did this:

$result = mysqli_query($con,"SELECT * FROM playerdata WHERE AdminLevel = '6'");

That did not work

[requinix]

Well duh, "AdminLevel = 6" is very different from the "AdminLevel set to 1 or higher" you said you wanted.

[Irate]

WHERE AdminLevel >= 1 should do the job perfectly fine.