Motore con campi selezionabili e campo testo

[searedone]

ho fatto così ma niente

  <?php
  
  require ("db_connect.php"); 
  

$aid = $_POST['aid'];  
    $bid = $_POST['bid'];
     $descrizione = $_POST['descrizione'];  

  
  $fascias = @mysql_query ("SELECT id, fascia FROM fascia WHERE id LIKE '%$cerca%'  OR fascia LIKE '%$cerca%'");
  if (!$fascias) {
  
  exit('

unable to obtain fascias </p>');
  
  }
  
  $tipos = @mysql_query ("SELECT id, tipo FROM tipo  WHERE id LIKE '%$cerca%'  OR tipo LIKE '%$cerca%'");
  if (!$tipos) {
  
  exit('

unable to obtain tipos </p>');
  
  }
  
  
 
  

  
  ?>
  
  <form action="prova2.php" method="post">
  
  <label>Fascia prezzo:
  </label>

 

<select name="aid" size="1">
  <option selected value="">Seleziona fascia</option>
 
<?php
   while ($fascia = mysql_fetch_array($fascias)) {
    $aid = $fascia['id'];
    $afascia = htmlspecialchars($fascia['fascia']);
    echo "<option value='$aid'>$afascia</option>\n";
  }
  ?>
</select></p>


<select name="bid" size="1">
  <option selected value="">Seleziona tipo annuncio</option>
  
<?php
   while ($tipo = mysql_fetch_array($tipos)) {
    $bid = $tipo['id'];
    $btipo = htmlspecialchars($tipo['tipo']);
    echo "<option value='$bid'>$btipo</option>\n";
  }
  ?>
</select></p>


<label>Containing text: <input type="text" name="searchtext" />
</label>

<input type="submit" value="Search" />

prova2.php

<?php
require "db_connect";


query = mysql_query ("SELECT * FROM annunci WHERE descrizione LIKE '$_POST[searchtext]' AND fascia = '$_POST[aid]' AND tipo = '$_POST[bid]'";

while($row= mysql_real_escape_string($query)) {  
$click_annuncio = $row['click_annuncio']; 
$id_annunci = $row['id_annunci']; 
$user_id = $row['id']; 


 echo"$descrizione"; 
  echo"$aid"; 
  echo"$bid"; 
 
 
 ?>