Thread: Displaying Data from a Drop Down List

I'm struggling with displaying details from a selected option in a drop down list.

I have a drop down list which is populated from a MYSQL query. I want the user to select an option and the values associated pulled from the database and displayed.

The dynamically populated drop down list is for "Brand" and when a user selects the brand from the drop down list I want the "supplier" of that brand to be displayed.

The code below is for dynamically populating the drop down list. I'm just not sure on how to produce the next step.

Code:

 
<form id="form1" name="form1" method="get" action="<?php echo $PHP_SELF; ?> ">
<strong>Brand:</strong>
<select name="select">
<option value="">--- Please Select Brand ---</option>
<?php
// Get records from database (table "name_list").
$list=mysql_query("select * from who_supplies_us_what order by brand asc");
// Show records by while loop.
while($row_list=mysql_fetch_assoc($list)){
?>
<option value="<?php echo $row_list['brand']; ?>" <?php if($row_list['brand']==$select){ echo "selected"; } ?>><?php echo $row_list['brand']; ?></option>
<?php
// End while loop.
}
?>
</select> 
<input type="submit" name="Submit" value="Select" />
</form>

Many thanks

well, when the user submits the form, the selected brand will be stored in $_POST['select']. You can then use this value to select the supplier?

Pseudocode:

Code:

<?php

if(isset($_POST['select']))
{
  $brand=mysql_real_escape_string($_POST['select']);
  $result=mysql_query("SELECT supplier FROM suppliers WHERE brand='".$brand."';
  $row=mysql_fetch_assoc($result);
  print $row['supplier'];
}

?>

well, when the user submits the form, the selected brand will be stored in $_POST['select']. You can then use this value to select the supplier?

Pseudocode:

Code:

<?php

if(isset($_POST['select']))
{
$brand=mysql_real_escape_string($_POST['select']);
$result=mysql_query("SELECT supplier FROM suppliers WHERE brand='".$brand."';
$row=mysql_fetch_assoc($result);
print $row['supplier'];
}

?>

Originally Posted by janvt

Many thanks for the quick response I'll give this a try.

well, when the user submits the form, the selected brand will be stored in $_POST['select']. You can then use this value to select the supplier?

Pseudocode:

Code:

<?php
 
if(isset($_POST['select']))
{
  $brand=mysql_real_escape_string($_POST['select']);
  $result=mysql_query("SELECT supplier FROM suppliers WHERE brand='".$brand."';
  $row=mysql_fetch_assoc($result);
  print $row['supplier'];
}
 
?>

Originally Posted by janvt

Many thanks worked a treat!

Only thing is for some of my brands I have several suppliers for and it only returns one supplier. How to I display all suppliers?

Once again many thanks for your quick response much appreciated.

Got it sorted Now. Many thanks for your help.

For anyone interested the I have posted the completed code below.

Code:

<form id="form1" name="form1" method="POST" action="<?php echo $PHP_SELF; ?> ">
<strong>Brand:</strong>
<select name="select">
<option value="">--- Please Select Brand ---</option>
<?php
// Get records from database (table "name_list").
$list=mysql_query("select * from who_supplies_us_what order by brand asc");
// Show records by while loop.
while($row_list=mysql_fetch_assoc($list)){
?>
<option value="<?php echo $row_list['brand']; ?>" <?php if($row_list['brand']==$select){ echo "selected"; } ?>><?php echo $row_list['brand']; ?></option>
<?php
// End while loop.
}
?>
</select> 
<input type="submit" name="Submit" value="Select" />
</form>
<br />
<p>
<?php
if(isset($_POST['select']))
{
  $brand=mysql_real_escape_string($_POST['select']);
  $result=mysql_query("SELECT supplier FROM who_supplies_us_what WHERE brand='".$brand."'");
  while ($row=mysql_fetch_assoc($result)) {
  echo '<strong>Supplier: </strong>'; echo $row['supplier']; echo '<br />';
}
}
?>

PHP Code:


if(isset($_POST['select']))
{
  $brand=mysql_real_escape_string($_POST['select']);
  $result=mysql_query("SELECT supplier FROM suppliers WHERE brand='".$brand."'";
 while( $row=mysql_fetch_assoc($result)) {
  print $row['supplier'];
  }
} 


Hope that helps.