[PHP-DB] Not getting option value from my database...

2009-04-17 Thread Carol Walter 

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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Not getting option value from my database...

2009-04-17 Thread danaketh 
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: m...@danaketh.com
ICQ: 160914875
MSN: danak...@hotmail.com
Jabber: danak...@jabbim.cz