Re: [PHP-DB] 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: [email protected]
ICQ: 160914875
MSN: [email protected]
Jabber: [email protected]