Entrar
Cadastre-se
Ajuda
Segue script
<?php
$depto = $_POST["depto"];
$nome = $_POST["nome"];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<table width="500" border="1">
<tr>
<form action="" method="post" name="form2">
<td>Departamento;</td>
<td><?php
include"config_layout.php";
$sql = "SELECT * FROM depto";
$Execute = mysql_query($sql) or die( mysql_error());
echo "<select name=\"depto\">";
while ($oBject=mysql_fetch_object($Execute))
{
$depoto=$oBject->descricao;
echo "<option>$depoto</option>";
}?>
<input name="submit" type="submit" value="Enviar" /></td>
</form>
</tr>
<tr>
<form action="" method="post" name="form2">
<td>Chamado</td>
<td><?php
if(!empty($depto))
{
include"config_layout.php";
$sql = "SELECT DISTINCT(nome) FROM chamados where setor = '$depto'";
$Execute = mysql_query($sql) or die( mysql_error());
echo "<select name=\"nome\">";
while ($oBject=mysql_fetch_object($Execute))
{
$nome=$oBject->nome;
echo "<option>$nome</option>";
}
echo "</select>";
}
else
{
echo "É necessário selecionar primeiro o depto";
}
?><input name="submit" type="submit" value="Enviar" /></td>
</form>
</tr>
<tr>
<form action="" method="post" name="form2">
<td>Nome</td>
<td><?php
if(!empty($nome))
{
include"config_layout.php";
$sql = "SELECT sms_benner FROM chamados where nome = '$nome'";
$Execute = mysql_query($sql) or die( mysql_error());
echo "<select name=\"sms\">";
while ($oBject=mysql_fetch_object($Execute))
{
$sms=$oBject->sms_benner;
echo "<option>$sms</option>";
}
echo "</select>";
}
else
{
echo "É necessário selecionar primeiro o depto";
}
?></td>
</form>
</tr>
<tr><td><input name="submit" type="submit" value="Enviar" /></td></tr>
</table>
</body>
</html>Ah depois necessito ainda colocar um form para direcionar todas as escolhas para uma outra pagina.
Quote