<?php $server_ip = "localhost"; $mysql_user = ""; $mysql_pass = ""; $database = ""; $connect = mysql_connect("$server_ip", "$mysql_user", "$mysql_pass") or die(mysql_error()); $db_select = mysql_select_db("$database", $connect) or die(mysql_error()); $gm_list = mysql_query("SELECT char_name,accesslevel,online FROM characters WHERE accesslevel>=1") or die(mysql_error()) ; echo'<table border="0">'; while($row=mysql_fetch_array($gm_list)){ $nick = $row['char_name']; $online = $row['online']; if($online == 1){ $online = 'Online'; }else{ $online = 'Offline'; } echo'<tr><td>'.$nick.'</td><td>['.$online.']</td></tr>'; } echo'</table>'; mysql_close($connect);?>