search with drop-down menu

Anon

I have a drop-down menu that takes value from my database. How to display the record based on the selected product.
My drop-down menu
<select name="share" >
<?php
include "./common_syslist.inc";
$link_id = db_connect();
mysql_select_db("$default_dbname");

$one = "select product from $user_tablename order by product";
$result = mysql_query($one);

while (list($product) = mysql_fetch_row($result))
{
print "<option value=\"$product\">$product</option>\n";
}
mysql_close($link_id);

?>
</select>

Anon

font face=Verdana,Helvatica,Arial SIZE=2>    Nama Product:

  <select name=share>

  $sql = "SELECT DISTINCT product FROM $user_tablename;";

  $result_1 = mssql_query( $sql );

  if (!$result_1)
  {
    echo "Berlaku kesilapan semasa memilih product";
    exit;
  }

  $jum_1 = mssql_num_rows ($result_1);

  for ($i=0; $i<$jum_1; $i++)
  {

    $vnama  = mssql_result($result_1, $i, "fields name in table $user_tablename(product)");

<option value='$vnama'>".$vnama;
}

  if ($i==0 )
  {
      $n_product = $vnama ;
  }

  echo "</select>";

Anon

How to search based on the drop-down menu?

hometoast

do you mean to load a page (that shows information based on the item chosen) after the pull-down changes? if so, its a javascript problem, use the OnChange event in the select tag.