<?
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>&nbsp;</td>";
echo"<td>&nbsp;</td></tr>";


?>
<?
 }
?>
<?
echo"</table>";
?>

Reply via email to