<tr align="center">
<td><span style="font-size: 30px;color: #901b1b;font-weight: bold;">Married Users</span></td>
</tr>
<tr>
</tr>
</table>
<BR>
<div align="center">
<table width="50%" class="themain" align="center" cellspacing="0" cellpadding="2"><tr><td>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td align="center" class="topp1">Wife</td>
<td align="center" class="topp3">Husband</td>
</tr>
<?
$query=mssql_query("select TOP 50 * from MuOnline.dbo.Character Where (IsMarried = '1') and (class like '34') or (IsMarried = '1') and (class like '33') or (IsMarried = '1') and (class like '32') or (IsMarried = '1') and (class like '80') or (IsMarried = '1') and (class like '81') or (IsMarried = '1') and (class like '82') order by Name ASC");
while($row=mssql_fetch_assoc($query)){
$namez=$row['Name'];
$marriedwith=$row['MarryName'];
?>
<tr>
<td class="trhover" align="center"><?=$namez;?></a></td>
<td class="trhover" align="center"><?=$marriedwith;?></td>
</tr>
<?
}
?>
</table>
</td></tr></table><BR>
</div>
<br><br>
</body>
</html>