Good morning,
I need to pull data from the database, but wanted the user to choose from which data what value to search.
My code html
:
<head>
<title></title>
</head>
<body>
<form method="POST" name="frmBusca" action="Exibindo.php">
Pesquisar pedido:<input type="text" name="busca" id="busca">
<input type="submit" value="Buscar" name="buscar">
<select name="opcao">
<option>Numero bl</option>
<option>Conteiner</option>
</select>
</form>
</body>
Now there in php
:
<?php
$conexao = mysql_connect("localhost", "root", "") or die(mysql_error());
$banco = mysql_select_db("cliente_svn") or die(mysql_error());
$busca = $_POST['busca'];
$opcao = $_POST['opcao'];
case ($opcao = "Numero bl"):
I wanted to know the correct formatting to call case
.
Thank you!