Here's what I have t the moment:
<?php
mysql_connect("ADDRESS", "USER", "PASSWORD") or die(mysql_error());
mysql_select_db("DATABASE") or die(mysql_error());
$result = mysql_query("SELECT s.ip_address,s.game_port,g.display_name,g.query_protocol,g.game_id,ls.online,ls.map,ls.name,ls.max_players,ls.players,ls.service_id
FROM tc_game_services s
INNER JOIN tc_games g ON s.game_id = g.game_id
INNER JOIN tc_game_service_live_stats ls ON s.service_id = ls.service_id
WHERE online = 1
ORDER BY g.display_name ASC, ls.name ASC") or die(mysql_error());
while($row = mysql_fetch_array($result)){
echo "<li><img src='images/gameimages/mini/16/" . $row['game_id'] . ".png' border='0' width='16px' height='16px' /> <a href='http://www.gametracker.com/server_info/" . $row['ip_address'] . ":" . $row['game_port'] . "' target='_blank'>" . $row['ip_address'] . ":" . $row['game_port'] . "</a> (" . $row['players'] . "/" . $row['max_players'] . ")</li>";
}
?>
So I have the address and online/max slots. Only thing I'm having trouble with is showing only the results by userid 15.
Anyone shed any light?