Combo Box #2

[Remote4ever]

I need to put this into a combo box

$result = mysql_query("SELECT FacultyID, SSN, FirstName, LastName FROM Faculty ORDER BY LastName, FirstName", $conn);
while ($row = mysql_fetch_array($result))
print "<a href=\"{$_SERVER["PHP_SELF"]}?FacultyID={$row["FacultyID"]}\">{$row["FirstName"]} {$row["LastName"]}</a><br>\n";
}

Can someone give me the code. That code just lists the names in a long row. I need it to link when I select a name as well.

[packland]

I'm new to this stuff but i reckon i can help you out here because i've just been through this.

1.

<?
probably need something at the start if you have values already
eg. if($FacultyID){ then you just sent some values so do something - eg find which item in the list is current or create some tmp variables. if you need to reselect the last selection do it in the while loop with an if statement that tests oldID = newID and adds selected} if is true

2. create the meat for the select statement from the database.

optionsblock = "
while ($row = mysql_fetch_array($result)) {
$FacultyID = $row['FacultyID']
$SSN = $row['SSN'];
$FirstName = $row['FirstName'];
$Lastname = $row['Lastname'];
$option_block .= "<option value=\"$SSN\">$FirstName.$Lastname</option>";
"

2. in the html build the select statement.

<FORM NAME="combo_select" METHOD="post" action= <? echo "$PHP_SELF" ?>>
<select name="drop_down">
<? echo "$option_block"; ?>
<input type="text" name="FacultyID" VALUE = $tmpFacultyID>
<input type="text" name="SSN" value=tmpSSN">
<input type="text" name="FirstName" value= $tmpFirstName>
<input type="text" name="LastName" value=$tmpLastName>
</select>
<P><input type="submit" name="submit" value="update list"></P>
</form>

is this what your looking for?

[packland]

to link to a url you'd have to use
onSelect="DoThis();" in the select statement
and write a javascript function to link to the url for the selection?

need more help?

I'm not exactly sure what your doing?

[packland]

Please not incorrect placement of </select> in previous listing! - sorry

<select name="drop_down">
<? echo "$option_block"; ?>
</select>
<input type="text" name="FacultyID" VALUE = $tmpFacultyID>
<input type="text" name="SSN" value=tmpSSN">
<input type="text" name="FirstName" value= $tmpFirstName>
<input type="text" name="LastName" value=$tmpLastName>
<P><input type="submit" name="submit" value="update list"></P>

[Remote4ever]

Thanks alot buddy. I will work with that code.

[packland]

i haven't checked the code it but i can work with you on this. Let me know how you go.