Not getting option value from my database...

[email protected] (Carol Walter)
Newsgroups php.db
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.