extracting dtabase data into 2 select boxes >>>

[localhost]

Hello!
Somebody please help me realise this!!

i would like to create a form with 2 select boxes
and one submit bottom
the elements of each select box get extracted from 2 SELECT querys
each time a user selects from the 2 boxes
and submits the values these values
will be used in another SELECT QUERY
HOW CAN I DO THIS???

[ahundiak]

Hmmm.
You are basically asking how to develop database driven web applications using php. It's a bit tough to answer in a short email.

I'd suggest you start by going to the article portion and reading the database articles.

You need to
1. Query the database
2. Use the resulting data to output a html form with two select fields.
3. Read the resulting posted data.
4. Generate a new query usding the posted data.

[localhost]

Originally posted by ahundiak
Hmmm.
You are basically asking how to develop database driven web applications using php. It's a bit tough to answer in a short email.

I'd suggest you start by going to the article portion and reading the database articles.

You need to
1. Query the database
2. Use the resulting data to output a html form with two select fields.
3. Read the resulting posted data.
4. Generate a new query usding the posted data.

there is no problem with the querys
i only need help to output the form!!
thanks

[ahundiak]

Fair enough. Here is an example of creating a form with two select elements.

<?php

function main()
{
  echo '<h1>Select Generation</h1><br />' . "\n";

  /* See if have posted data */
  if (isset($_GET['animal'])) {
    echo 'Posted Animal ' . $_GET['animal'] . "<br />\n";
    echo 'Posted Plant  ' . $_GET['plant']  . "<br />\n";
  } 

  /* Build a couple of select lists */
  $data1 = array('Cat','Dog','Bird');
  $data2 = array('Tree','Bush','Flower');

  echo '<form action="select.php" method="get" name="myname">' . "\n";

  echo '<select name="animal">' . "\n";
  foreach($data1 as $data) {
    echo '<option value="' . $data . '">' . $data . '</option>' . "\n";
  }
  echo '</select><br />' . "\n";

  echo '<select name="plant">' . "\n";
  foreach($data2 as $data) {
    echo '<option value="' . $data . '">' . $data . '</option>' . "\n";
  }
  echo '</select><br />' . "\n";

  echo '<input type="submit" value = "Submit" /><br />' . "\n";

  echo '</form>' . "\n";

}
main();
?>

[localhost]

thanks a lot for your help!
cheers!