Display selected dropdown value to html form

cadac

I think i'm half way there with this issue. Basically i've got a dropdown box which gets mysql data and displays it. I am now trying to figure out how to post that dropbox value with it's mysql data into a html form with textboxes.

I've attached a screenshot of what the page looks like and i've copied in the code done so far.

Any help would make my day, and my headache go away 🙂 Thanks

	  <?php

include('includes/connect.php');

echo "Select a Member: <select name='member-list'>";
$query="select member_id, firstname, lastname from members ORDER BY firstname asc";
$result=mysql_query($query);
while($row=mysql_fetch_array($result)){
$id=$row['member_id'];
$fname=$row['firstname'];
$lname=$row['lastname'];
echo "<option value='".$row['member_id']."'>".$row['firstname']." ".$row['lastname']."</option>"; 
}
echo "</select>";
?>

sfullman

not sure I understand your post esp. related to "chekboxes". When you receive the post on another page you'll have a variable named $_POST['member-list'] - however I suggest you change the name to not have the - in the field name - why not member_id since that is obviously the name of the key in members table?

also, if this form is to "populate" data, then you need to add the following below:


//suppose your ap was called on this page as members.php?member_id=237 .. 
echo "Select a Member: <select name='member_id'>";
$query="select member_id, firstname, lastname from members ORDER BY firstname asc";
$result=mysql_query($query);
while($row=mysql_fetch_array($result)){
$id=$row['member_id']; //why do you have these? they are not being used!!!! suggest you lose these three lines
$fname=$row['firstname'];
$lname=$row['lastname'];
echo "<option value='".$row['member_id']."' ".($member_id==$row['member_id'] ? 'selected' : '').">".$row['firstname']." ".$row['lastname']."</option>";
}
echo "</select>";

cadac

Thanks for the tips. I'm not getting any values from other pages.

From the attached image all I want to achieve is, once they've selected that name from the db those values that are contained in the mysql table are populated in the textboxes below so another script can be executed to update the fields?

If that makes more sense?

I prob need to use echo tags inside the textboxes it's just the code to execute the retrieve of data. Something to do with the form? on change or something that kicks in after someone has selected a dropbox value.