Code: Select all
<?php
include("dtb.php");
?>
<html>
<body>
<style>
td {
border: solid 1px black;
}
</style>
<?php
$query = "SELECT
GM.membername, PC.classname AS priclassname, GM.priclasslvl, SC.classname AS secclassname, GM.secclasslvl, GD.guildname, GM.rank, GD.ID as guild_id, GM.ID as member_id, GM.notice, GD.publishranks, GD.publishnote, S.ID server_id, S.servername
FROM
GuildMembers GM
LEFT JOIN GuildData GD on GuildData_ID=GD.ID
LEFT JOIN Classes PC on priclassid=PC.ID
LEFT JOIN Classes SC on secclassid=SC.ID
LEFT JOIN Servers S on GD.Servers_ID=S.ID
WHERE GM.deleteflag = 0 ORDER BY membername ASC";
$result = mysql_query($query);
echo "<table>";
while ($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>",$row[membername],"</td>";
echo "<td>",$row[priclassname],"</td>";
echo "<td>",$row[priclasslvl],"</td>";
echo "<td>",$row[secclassname],"</td>";
echo "<td>",$row[secclasslvl],"</td>";
echo "</tr>";
}
echo "</table>"
?>
</body>
</html>