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]