[RESOLVED] populating drop down boxes from database

[irishgirl2004]

Hi,
I have two drop down boxes, the first one i am able to fill from my database using the following code.

				$query = "Select * from countries;";
				$result1 = mysql_query($query);
				if (mysql_num_rows($result1) > 0)		
				{
					while ($myrow1 = mysql_fetch_array($result1)) 
					{
					echo "<option value='$i' $selected>$myrow1[1]</option>";
					}

				}

I want to load the second one, depending on what is selected in the first, is this possible?

thanks

[Roger_Ramjet]

Yes. Lots of ways to do this as well. At one time the method would have been with javascript a la Chained Selects, but today I would just go with AJAX a la Google Hints.

[irishgirl2004]

have been looking around but cant seem to find an ajax example, does anybody have a link to one?

[Roger_Ramjet]

Well a quick google for "ajax chained selects" will throw up loads of them for you to choose from.

Personally, I use Prototype for AJAX and would recommend it to anyone, really slick and easy to use.

[irishgirl2004]

cool, thanks for your help