RE: Problems with a simple While-If condition With the statement
| From: | Rodrigo de Oliveira | Date: | Wed, 27 Nov 2002 00:26:54 +0000 |
| Subject: | RE: Problems with a simple While-If condition With the statement | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-126208@lists.php.net to get a copy of this message | ||
<?
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>";
?>