Not getting option value from my database...
| From: | Carol Walter | Date: | Fri, 17 Apr 2009 13:08:59 +0000 |
| Subject: | Not getting option value from my database... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-46117@lists.php.net to get a copy of this message | ||
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 . " " . " ---". " " . $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