Populating a listbox

Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

I have a page I am working on that has a listbox. I want the listbox to populate with all team_id/team_names.

Example:

$nukeusername = $userinfo['username'];

Code:

$sql = "SELECT * FROM " . $prefix . "_eto_divisions WHERE div_commander ='$nukeusername'";

The div_commander has a div_id as well as all the rest of the teams on the "Allied" side. div_id = 1

The listbox is supposed to be for selecting any of the teams on the "Axis" side. div_id = 2

For whatever reason I can't get this to work.

Code:

. "               <td width=\"14%\"><p align=\"right\"><b>Enemy Unit: </b></font></td>"


  . "               <td width=\"16%\"><select name=\"team_id\" size=\"1\"><option value=\"\">--- Select Enemy ---</option>";


  //Team List Box for Enemy 


  $nukeusername = $userinfo['username'];  


  $mydiv = $db->sql_query("SELECT div_id FROM " . $prefix . "_eto_divisions WHERE div_commander ='$nukeusername'"); 





 // $mydiv = $db->sql_query("SELECT div_id FROM " . $prefix . "_tc_teams WHERE team_id = '$id'");


  


$result = $db->sql_query("SELECT * FROM " . $prefix . "_tc_teams tct WHERE tct.div_id != $mydiv AND tct.is_active = 1 ORDER BY tct.name");





while ( $row = $db->sql_fetchrow($result) ) {


   $team_name = $row["name"];


   $team_id = $row["team_id"];


   echo "<option value='$team_id'>$team_name</option>";   


}


echo""


  . "         </select>"

Posted: Sun Jul 30, 2006 9:57 pm

<bump>

Actually, I appologize in that I am not able to follow the requirement (or maybe it is the problem statement) and the code. I am just not following your "Allied" vs. "Axis". If this is already fixed, let us know. Otherwise, may need a bit more clarity on the functional requirement and translation to the table queries.

Are your queries correctly bringing back the data that you want?

Is it that the drop down list box isn't correctly populating (or rendered in the browser)?

Or, is it that your script that is processing the form is not reading the value that was selected?