At 4:28 PM -0500 1/10/02, Erik Price wrote:
>
>PS: what I am -really- trying to do is dynamically fill in a 
><select> listbox with <options> that correspond to all of the 
>records in a given table.  Like so:
>
><form>
>      <select>
>           <?php
>           foreach ($record_id_and_record_name_pair_pulled_from_mysql_query) {
>               print("<option value=\"${record_id}\">${record_name}</option>");
>           }
>           ?>
>       </select>
></form>
>
>but I am unsure of how to grab multiple values from the 
>mysql_query() and load them into an array.  Has anyone done this 
>before?
>

I've just recently done something very similar. The code is below. It 
looks a bit different  because I like to include very little HTML in 
my PHP. But otherwise the concept should be the same.

I should mention, that my code actually produces two pull down menu. 
My ultimate goal was to add a javascript to the sequence, so that 
when a user selects the item in the first pull down, it resubmits the 
query for the second pull down, and allows for pull down two to be 
dependent on pull down one. I haven't worked on the javascript as of 
yet.

......................
$staffID=$id;
$results=mysql_query ("

SELECT          staff.staffID, teamMembers.accountID, 
accounts.clientID, clients.orgID,
                orgs.name AS client, accounts.description AS account

FROM            staff, clients, orgs, accounts LEFT JOIN teamMembers ON
                teamMembers.accountID=accounts.accountID

WHERE           teamMembers.staffID=\"$staffID\" AND
                teamMembers.accountID=accounts.accountID

GROUP BY        accounts.description

ORDER BY        orgs.name") or die("I've failed! Woe is ME!");

while ($row=mysql_fetch_array($results)){
                $staffID                = $row["staffID"];
                $accountID      = $row["accountID"];
                $clientID               = $row["clientID"];
                $orgID          = $row["orgID"];
                $client         = $row["client"];
                $account                = $row["account"];

//      After the array is created, a small if elseif script is used 
to create the select menu.
//      Ideally the to menus will be separate scripts, I just want to 
test the theory first

if($clientID != ""){

        $selectClient .=
        "<option value=\"$clientID\" selected=\"$client\">$client</option>\n";
} else {

        $selectClient .=
        "<select id=\"clientID\" name=\"client\">
        <option value=\"\" selected=\" \">&nbsp;</option>\n";
}

//      Pull down list2, this displays the accounts pull down.

if($accountID != ""){

        $selectAccount .=
        "<option value=\"$accountID\" 
selected=\"$account\">$account</option>\n";

} else {
        $selectClient .=
        "<select id=\"accountID\" name=\"account\">
        <option value=\"\" selected=\" \">&nbsp;</option>\n";
        }
}

?>

<!-- This Script is a Modification of Code Created By Joe Chellman to 
auto create pull down menus from enum (value lists). I've adjusted it 
to just pull field data -->

<p><select id="clientID" name="client">
        <option value=" " selected=" ">&nbsp;</option>
        <?      echo"$selectClient\n"; ?>
       </select></p>

<p></p>

<p><select id="accountID" name="account">
        <option value=" " selected=" ">&nbsp;</option>
        <?      echo"$selectAccount\n"; ?>
       </select></p>
...................................

-- 
   .........................................
    Alnisa  Allgood
    Executive Director
    Nonprofit Tech
    (ph) 415.337.7412  (fx) 415.337.7927
    (url)  http://www.nonprofit-techworld.org
    (url)  http://www.nonprofit-tech.org
    (url)  http://www.tech-library.org
   .........................................
    Nonprofit Tech E-Update
    mailto:[EMAIL PROTECTED]
   .........................................
    transforming nonprofits through technology
   .........................................

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to