<select> not populating form fields (php,mysql)

Situation:

I have a form which collects a bunch of data. The form accesses two tables
(users and assignment_details). The user table is accessed to get the
userid (to be saved in an assignment_details record) and to display other
users table info (for display only). There is other information being
collected to be saved in the assignment_details table, but it is not
relevant to the issue.

I am using a <select> to display user names, and extract the appropriate
userid. The <select> tag uses a query to pull all the names from the users
table. When the form is loaded all defined fields from the users table are
displayed on the form. Selecting a different name doesn't result in
extracting and displaying the result of the user fields (as in the code
below): ... help!
..
..
..
<td><select name="adetails_employee_id">
<?php
do {
?>
<option value="<?php echo
$row_rsEmployeeLookup['id_usr']?>"><?php echo
($row_rsEmployeeLookup['first_name_usr'] . ' ' .
$row_rsEmployeeLookup['last_name_usr']);?></option>
<?php
} while ($row_rsEmployeeLookup = mysql_fetch_assoc($rsEmployeeLookup));
$rows = mysql_num_rows($rsEmployeeLookup);
if($rows > 0) {
mysql_data_seek($rsEmployeeLookup, 0);
$row_rsEmployeeLookup = mysql_fetch_assoc($rsEmployeeLookup);
}
?>
</select>
</td>
</tr>
<tr>
<td>mobile phone</td>
<td><?php echo $row_rsEmployeeLookup['mobile_usr']; ?></td>
</tr>
etc.


.

Relevant Pages

  • Re: control cant be edited it is bound to an unknown field
    ... UserId in the form's RecordSource. ... >from the query UserID is one of them. ... >turning Display Column Heads to Yes. ... >must be missing something. ...
    (microsoft.public.access.forms)
  • RE: Meeting Room Booking display problem
    ... I also have the feeling that it should be a cross tab. ... I am trying to create a meeting room booking database. ... display a grid by day of the available and used time slots. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Display a document simultaneously with the Logon dialog in Win2000?
    ... Since it would appear the sys is not going to be accessible to others why ... bother with a user password? ... I like to display some text reminding him what his UserID and password ...
    (microsoft.public.win2000.general)
  • Re: Display a document simultaneously with the Logon dialog in Win2000?
    ... You could try telling him what his username and password is and then place a word document in the STARTUP folder of windows, and then it will load when he logs in, then you can always give him instructions on how to remove that along with other info. ... I like to display some text reminding him what his UserID and password ...
    (microsoft.public.win2000.general)
  • Real dificult SP ... is it even possible ?
    ... I have been thinking and thinking how to do this query, ... Table two links users to cases (Users is another table, ... UserId - Integer ... I need to display on page two all cases in which the selected users are ...
    (microsoft.public.sqlserver.programming)