Hi,
Please keep in mind that I am a newbie to PHP, however I have just solved
this same type of problem (for County, City, and Zip) as follows:
// COUNTY
print "<tr>";
print "<td align=\"right\"><b class=\"highlightColor\">*
</b>County:</td>";
print "<td align=\"left\">";
if ($countyX != "") { $county = $countyX; }
print "<select name=\"countyChoice\"
onChange=\"window.location.href=document.$formname.countyChoice.options[docu
ment.$formname.countyChoice.selectedIndex].value\"> ";
print "<br><option value=\"\" class=\"fieldStyle\">";
$result = mysql_query("SELECT county FROM $db2.alabama GROUP BY county
ORDER BY county;",$link);
while ($a_row =mysql_fetch_array ($result) )
{
$countySelect = $a_row[county];
print "<br><option
value=\"selleradmin.php?DP=$DP&edit=$edit&IN=IN&county=$countySelect&countyX
=$countySelect&formname=$formname\" class=\"fieldStyle\"";
if ($county == $countySelect) { print " SELECTED"; }
print ">$countySelect";
}
print "</select>";
print "<input type=\"hidden\" name=\"county\" value=\"$county\">";
print "</td>";
print "</tr>";
// CITY
print "<tr>";
print "<td align=\"right\"><b class=\"highlightColor\">* </b>City:</td>";
print "<td align=\"left\">";
if ($cityX != "") { $city = $cityX; }
print "<select name=\"cityChoice\"
onChange=\"window.location.href=document.$formname.cityChoice.options[docume
nt.$formname.cityChoice.selectedIndex].value\"> ";
print "<br><option value=\"\" class=\"fieldStyle\">";
$result = mysql_query("SELECT city FROM $db2.alabama WHERE
county='$county' GROUP BY city;",$link);
while ($a_row =mysql_fetch_array ($result) )
{
$citySelect = $a_row[city];
print "<br><option
value=\"selleradmin.php?DP=$DP&edit=$edit&IN=IN&county=$county&countyX=$coun
ty&city=$citySelect&cityX=$citySelect&title=$title&formname=$formname\"
class=\"fieldStyle\"";
if ($city == $citySelect) { print " SELECTED"; }
print ">$citySelect";
}
print "</SELECT>";
print "<input type=\"hidden\" name=\"city\" value=\"$city\">";
print "</td>";
print "</tr>";
// Zip
print "<tr>";
print "<td align=\"right\">Zip:</td>";
print "<td align=\"left\">";
print "<SELECT NAME=\"zip\" value=\"$zip\" class=\"fieldStyle\">";
print "<br><option value=\"\" class=\"fieldStyle\">";
$result = mysql_query("SELECT * FROM $db2.alabama WHERE
(county='$county' AND city='$city') GROUP BY zip;",$link);
while ($a_row =mysql_fetch_array ($result) )
{
$zipSelect = $a_row[zip];
print "<br><option value=\"$zipSelect\" class=\"fieldStyle\"";
if ($zip == $zipSelect) { print " SELECTED"; }
print ">$zipSelect";
}
print "</SELECT>";
print "</td>";
print "</tr>";
I hope this helps, and am very open to any feedback from more experienced
users as to how this may not be the best solution.
Jackie
----- Original Message -----
From: Tom Rogers
To: Mike Walth
Cc: [EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 8:19 PM
Subject: Re: [PHP] Generating Related Drop Down Boxes
Hi,
Thursday, June 12, 2003, 5:19:00 AM, you wrote:
MW> Hello all:
MW> I have searched the archives, and although I know this is probably there
can
MW> not find it. I'm probably just not searching for the right subject.
Here
MW> is what I am looking for.
MW> I have a table with Location and Hotel, and another one with Hotel and
MW> Accommodations. I need to generate the first drop down box with
locations.
MW> Then when you select a location it will place the corresponding hotels
in
MW> another drop down, when you select the hotel it will do the
accommodations.
MW> What I am looking for is if anyone has a sample or any information how
to do
MW> the drop downs that update themselves. If I can get a sample for one
I'm
MW> sure I can figure the rest out.
MW> As always, thank you for all your help.
MW> Mike Walth
MW> CinoFusion
Check this out
http://www.mattkruse.com/javascript/dynamicoptionlist/
--
regards,
Tom
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
