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 . " " . " ---". " " . $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@xxxxxxxxxxxx
ICQ: 160914875
MSN: danaketh@xxxxxxxxxxx
Jabber: danaketh@xxxxxxxxx
