Re: Not getting option value from my database...

Can't say for sure where the problem is but seems to me that you're using global variables instead of $_GET and $_POST. After sending the form, you should access it's content using $_POST...

if (isset($_POST['get_name']))    {

echo "People Id = ".$_POST['GetName']."<br/>"; } This should solve the problem of yours. Carol Walter napsal(a):

Hello, I am trying to get an option value from a database. I'm using the following code snippet. This is a postgres 8.3.6 database. I am able to use echo to get a list from the database. The code appears to work, but later when I try to echo the id from the selected record, I get no result. What I'm trying to do, is select the appropriate row from the database using the options menu construct.

                  <form method="POST">

<? echo "<p> Choose your prospect:<br /><select name='GetName' size='". $rows ."'>";

              while (list($peopleId, $fName, $mName, $lName, $contactItem) = pg_fetch_row($SciName))
                 {
                 echo "<option value='".$peopleId."'> ". $fName .  " " . $mName . " " .$lName . "&nbsp;" . " ---". "&nbsp;" . $contactItem . "</option>";
                 }
              echo "</select>";

?>

            <br />
            <br />
             <input type="submit" name="get_name" value="Submit" />
           <input type="reset" value="Reset" /></p>
           </form>

<? }

          }
if ($get_name == "Submit") { echo "People Id = " . $peopleId. "<br />";  }

Thank you for your time, Carol Walter

-- S pozdravem Daniel Tlach Freelance webdeveloper Email: mail@danaketh.com ICQ: 160914875 MSN: danaketh@hotmail.com Jabber: danaketh@jabbim.cz