forms in php

[pak4eva]

Hi guys, i just wnated to know how i can use php script for my form that i have created in html, basically the code is below, what i want to do is when a user selects metal then it should display metals from the database, if metalloids selected then again it should retrieve that info from database.....

 

      <form name="input" action="type.php" method="get">

        <select name=group>

          <option>Select Type</option>

          <option>Metals</option>

          <option>Metalloids</option>

          <option>Non-Metals</option>

        </select>

        <input name="search2" type="submit" value="search">

      </form>

 

If possbile can someone post the actual script please. thanks.

[redarrow]

So you want to search the database with a drop down form and show those records selected?

[JasonLewis]

first your would need to give each option a value that is the same as what it will be in the database and change the method to POST instead of GET, or you could use GET but change all the $_POST below to $_GET

 

in the page type.php you would have code sort of like the below:

 

if(isset($_POST['search2'])){ //check to make sure submit was pressed

$option = $_POST['group'];
$query = "SELECT * FROM `table_name` WHERE `type`='{$option}'";
$sql = mysql_query($query) or die("Error: ".mysql_error()."<br>SQL: ".$query);

if($sql){ //make sure query worked
$data = mysql_fetch_array($sql);

echo $data['info']; //echo out the type information.
}

}

 

you can build off that if you need to.

[tauchai83]

in type.php

 

$select=$_POST['group'];

 

$sql="SELECT * FROM db WHERE xx='$select'";

$result=mysql_query($sql);

mysql_fetch_assoc($result);

 

and so on...depend what you want to do...this is a clue can help you go to correct direction.

 

thanks. Hope this help

 

[pak4eva]

Yes...

 

So you want to search the database with a drop down form and show those records selected?