Dynamic Drop Down

[FleXx]

Hello people,

This is my first post and I've given up all hopes and joined this forum. I am a php amateur but I really need this code. I have googled for a couple of days and I am trying to find a script that works best with dynamic drop down.

What I want is a state and city drop down, and I was wondering if any one can help me code it.

The table name for state is: t_countries
Id: countryid
name: countryname

The table for cities: t_cities
id: cityid
name: cityname

The script that I have right now is in a form of a collapse style. You click the state and you get a link of all the cities. I am trying to convert the code to a drop down.

Here's the code:

<?php



require_once("initvars.inc.php");

require_once("config.inc.php");



?>

<table width="300"><tr><td valign="top">

<?php



// Show city list



if($location_sort) 

{

$sort1 = "ORDER BY countryname";

$sort2 = "ORDER BY cityname";

}

else

{

$sort1 = "ORDER BY c.pos";

$sort2 = "ORDER BY ct.pos";

}



if ($show_region_adcount || $show_city_adcount)

{

// First get ads per city and country

$country_adcounts = array();

$city_adcounts = array();

$sql = "SELECT ct.cityid, c.countryid, COUNT(*) as adcnt

		FROM $t_ads a

			INNER JOIN $t_cities ct ON ct.cityid = a.cityid AND ($visibility_condn)

			INNER JOIN $t_countries c ON ct.countryid = c.countryid

		WHERE ct.enabled = '1' AND c.enabled = '1'

		GROUP BY ct.cityid";



$res = mysql_query($sql) or die(mysql_error().$sql);



while($row=mysql_fetch_array($res))

{

	$country_adcounts[$row['countryid']] += $row['adcnt'];

	$city_adcounts[$row['cityid']] += $row['adcnt'];

}

}



$sql = "SELECT * FROM $t_countries c INNER JOIN $t_cities ct ON c.countryid = ct.countryid AND ct.enabled = '1' WHERE c.enabled = '1' GROUP BY c.countryid $sort1";

$resc = mysql_query($sql);



$country_count = mysql_num_rows($resc);

//$split_at = ($country_count%3?((int)($country_count/3))+2:($country_count/3)+1);

$percol = floor($country_count/$location_cols);

$percolA = array();

for($i=1;$i<=$location_cols;$i++) $percolA[$i]=$percol+($i<=$country_count%$location_cols?1:0);



$i = 0; $j = 0;

$col = 1;

while($country = mysql_fetch_array($resc))

{

if($sef_urls) $country_url = "{$vbasedir}-$country[countryid]_" . RemoveBadURLChars($country['countryname']) . "/";

else $country_url = "?cityid=-$country[countryid]&lang=$xlang";



?>





<div id="city"><a href="<?php echo $country_url; ?>" class="citylist_country"><?php echo $country['countryname']; ?> <?php if($show_region_adcount) echo "(".(0+$country_adcounts[$country['countryid']]).")"; ?></a></div>



<div id="city1">

<?php



if($country['countryid'] == $xcountryid || !$expand_current_region_only)

{



	$sql = "SELECT * FROM $t_cities ct WHERE countryid = $country[countryid] AND enabled = '1' $sort2";

	$resct = mysql_query($sql);



	while($city=mysql_fetch_array($resct))

	{

		if($sef_urls) $city_url = "{$vbasedir}$city[cityid]_" . RemoveBadURLChars($city['cityname']) . "/";

		else $city_url = "?cityid=$city[cityid]&lang=$xlang";



?></div>



		<a href="<?php echo $city_url; ?>" class="citylist_city"><?php echo $city['cityname']; ?> <?php if($show_city_adcount) echo "(".(0+$city_adcounts[$city['cityid']]).")"; ?></a><br>



<?php



	}

}



?>





<?php



$i++; $j++;

//if($i%$split_at == 0) echo "</td><td valign=\"top\">";

if ($j%$percolA[$col]==0 && $i<$country_count) { echo "</td><td valign=\"top\">"; $col++; $j=0; } 



}



?>

</div>

</div>

I am stressing out too much over this, I hope some one can help me with this.

[FleXx]

Okay so I tried this:

<?php

require_once("initvars.inc.php");
require_once("config.inc.php");

?>

<select name="country">
<?php

if ($data=='$t_countries') {  // first dropdown
          echo "<select name='$t_countries' onChange=\"dochange('$t_cities', this.value)\">\n";
	  $sql = "SELECT * FROM $t_countries c INNER JOIN $t_cities ct ON c.countryid = ct.countryid AND ct.enabled = '1' WHERE c.enabled = '1' GROUP BY c.countryid $sort1";
	  $resc = mysql_query($sql);
	  while ($row=mysql_fetch_array($resc)){   

               echo "<option value=\"$row[countryid]\" >$row[countryname]</option> \n" ;
          }
     } else if ($data=='$t_cities') { // second dropdown
          echo "<select name='t_cities' >\n";
          echo "<option value='0'>====choose cities ====</option>\n";                           

          	$sql = "SELECT * FROM $t_cities ct WHERE countryid = $country[countryid] AND enabled = '1' $sort2";
		$resct = mysql_query($sql);

	while($city=mysql_fetch_array($resct)){       
           echo "<option value=\"$city[cityid]\" >$city[cityname]</option> \n" ;
      }
 } 
 echo "</select>\n";  
?>



</select>

And the drop down list is empty. What am I doing wrong?