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=\" \"> </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=\" \"> </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=" "> </option>
<? echo"$selectClient\n"; ?>
</select></p>
<p></p>
<p><select id="accountID" name="account">
<option value=" " selected=" "> </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]
