Multiple Selection Menu Dilemma

From: Date: Sun, 07 Apr 2002 07:24:38 +0000
Subject: Multiple Selection Menu Dilemma
Groups: php.general 
Request: Send a blank email to php-general+get-91913@lists.php.net to get a copy of this message
Okay I have the following code so far.
        $sql = "SELECT stass_warrior FROM staff_assignments WHERE stass_pos = $pos_id AND stass_weekend = $initiation";
        if (!$query = mysql_query($sql))        error(mysql_error());
        $query = mysql_fetch_row($query);
        $sql = "SELECT war_id, CONCAT(war_lname, ', ', war_fname) FROM warrior, staff_roster WHERE war_id != 1 AND staff_weekend = $initiation AND staff_warrior=war_id ORDER BY war_lname";
        if (!$res = mysql_query($sql))  error(mysql_error());
        tr();
        echo TTT . '<th class="format" width="25%">' . $row[1] . '</th>' . B;
        echo TTT . '<td class="format">' . B;
        echo TTT . '<select name="position_' . $n . '[]" size="5" multiple>' . B;
        while($rec = mysql_fetch_row($res))     {
                ($query[0] == $rec[0] ? $selected =" selected" : $selected = "");
                printf("\t\t\t\t<option value=\"%s_%s\"%s>%s</option>\n", $pos_id, $rec[0], $selected, $rec[1]);
        }
        echo TTT . '</select>' . B;
        echo TTT . '</td>' . B;
        trc();
Now my problem is with the multiple feature of the drop down menu. The first query to the db resulting in the $query variable may contain more then one result. However only the last result will appear with the selected option. I need some code that is is going to display the selected option next to all the correct results in the drop down. Understand what I am needing? Thanks for your help Phillip

« previous php.general (#91913) next »