Drop down list

dips_007

hi can some one help me how do i connect to a database and populate a drop down list with the data of one column. Then using the data from that drop down list it filters the data in drop down list2

EG
drop down list = County
drop down list2 = city

Pig

If you want them on the same page, you need to use javascript. You will find it if you google for it.

dips_007

on diffrent pages will do but u will have to explain how to do it i am new to this

TTT

http://www.faqts.com/knowledge_base/index.phtml/fid/178
😃

dips_007

that link did not help the question was not ansered.

how would i hut connect one drop down list to a database??

Pig

If you don't mind it on seperate pages, you would simply start with a query on the broadest category. Let's say country. Then you would pass the country ID from the select box to another page, that would use that ID and get all the states that have that country ID as their parent. That page would query to get all the matching states, and produce a drop down. That list would then forward to a page with the state ID, etc.

You could even do this on one page by looking for different IDs. Check to see if state_id, city_id, country_id, etc is set.

dips_007

hav u got any example code i can use to connect to the database then?? so i can link the drop down list to it

LifeComITGuy

Hrm, if you don't mind reloading the page through post actions, you can do it all on one page.

i.e. lets say your page is called myloc.php


$isCountySet = @$_POST['county'];

if($isCountySet){
    $sql = "SELECT id, city FROM CITIES WHERE id = '$isCountySet'";
    $result = @mysql_query($sql, $connection) or die(mysql_error());

echo("<select name=\"city\">\n");
while($row = mysql_fetch_array($result)){
    $city = $row['city'];
    $ciID = $row['id'];

    echo("<option value=\"$ciID\">$city</option>\n");
}
echo("</select>\n");
} else {

 $sql = "SELECT id, county FROM COUNTIES";

 $result = @mysql_query($connection, $sql) or die(mysql_error());
 echo("<form action=\"myloc.php\" method=\"post\">\n");
 echo("<select name=county>\n");
 while($row = mysql_fetch_array($result)){
      $county = $row['county'];
      $coID = $row['coID'];

      echo("<option value=\"$coID\">$county</option>\n");
 }
 echo("</select>\n");
 echo("<input type=\"submit\" value=\"Load This County\">");
 echo("</form");
}

Of course, this code isn't anywhere near complete, but this is basically how I would do it.