Code: Select all
<table border="1" cellpadding="0" cellspacing="2" width="192">
<tr>
<td align="center">First Name</td>
<td align="center">Last Name</td>
<td align="center">Age</td>
<td></td>
</tr>
<?php
$sqluser = "SELECT * FROM User
Where Accepted='1'
ORDER BY UserFirstName ";
$queryuser = mysql_query($sqluser, $dbConn);
while ($spu = mysql_fetch_array($queryuser, MYSQL_ASSOC)) {
$idz = $spu['UserId'];
$sqld = "SELECT * FROM skills Where UserID='$idz' ";
$qd = mysql_query($sqld, $dbConn);
$spd = mysql_fetch_array($qd);
$truefalse = $spd['dance'];
if ($truefalse == 1){
?>
<tr>
<td align="center"><?=$spu['UserFirstName']?></td>
<td align="center"><?=$spu['UserSurname']?></td>
<td align="center"><?=$spu['UserAge']?></td>
<td>VIEW</td>
</tr>
<?php }} ?>
</table>