<? include "db_dados.php"; ?> <? $sql = "SELECT * FROM tb_tao WHERE area='$area'and status=1"; $res = @mysql_query($sql,$id) ?>
<? echo "<table width='100%' height='100%' border='0' align='center'>" ?> <? $rodrigo=mysql_fetch_array($res); if($rodrigo=false){ echo "<tr><td><div align='center'>Nenhum profissional cadastrado.</div></td></tr>"; } ?> <? while ($row = mysql_fetch_array($res)) { ?> <? echo"<tr><td>ID Profissional</td>"; echo"<td>".$row['id']."</td></tr>"; echo"<tr><td>Nome</td>"; echo"<td>".$row['nome']."</td></tr>"; echo"<tr><td>Profissão</td>"; echo"<td>".$row['area']."</td></tr>"; echo"<tr><td>Bairro</td>"; echo"<td>".$row['bairro']."</td></tr>"; echo"<tr><td>Telefone</td>"; echo"<td>".$row['telefone']."</td></tr>"; echo"<tr><td>E-mail</td>"; echo"<td>".$row['email']."</td></tr>"; echo"<tr><td>Telefone Celular</td>"; echo"<td>".$row['celular']."</td></tr>"; echo"<tr><td>Registro Profissional</td>"; echo"<td>".$row['regprof']."</td></tr>"; echo"<tr><td>Endereço</td>"; echo"<td>".$row['endereco']."</td></tr>"; echo"<tr><td> </td>"; echo"<td> </td></tr>"; ?> <? } ?> <? echo"</table>"; ?>