SELECT * FROM users Men kun vis state = member hvordan gør ma
Her er min kode...Den skal select * from users (Der er member) alså skal den ikke vise dem der er admin...
Hvordan gør jeg det...
<?
//
//
//
?>
<div align="center">Present members
<div align="center">
<table width="489" border="0">
<tr>
<th width="74" scope="col"><div align="left">Name</div></th>
<th width="93" scope="col"><div align="left">Race</div></th>
<th width="79" scope="col"><div align="left">Class</div></th>
<th width="55" scope="col"><div align="left">Contry</div></th>
<th width="67" scope="col"><div align="left">Time</div></th>
</tr>
<?
Db::Conn(open);
$loadin = mysql_query("SELECT * FROM users") or die("Der er en fejl med databasen");
while($Get = mysql_fetch_object($loadin)) {
print "<tr>" . "<td>$Get->player_name</td>" . "<td>$Get->race</a></td>" . "<td>$Get->class</a></td>" . "<td>$Get->location</a></td>" . "<td>$Get->time</td>" . "</tr>";
}
Db::Conn(close);
?>
</table>
