tengo una lista con las ciudades de mi provincia, como hago para cuando no existe la ciudad de una persona pueda seleccionar la opcion "otra.." y me aparezca un textbox para poder poner el nombre de su ciudad el codigo que uso (no es mio) es este:
formulario:
Código HTML:
<tr> <td align="left"><img src="images/bullete.gif" width="4" height="6" /> </td> <td align="left" class="wfrm2"><strong>Select Country</strong></td> <td width="731" align="left" valign="bottom"><label> <select name="country" id="country" style="width:300px" onchange="districtstatus()"> <option value="">--SELECT COUNTRY--</option> <?php $quyCountry="select * from country_name order by country_name asc"; $db_c = new DB(); $db_c->query( $quyCountry ); if( $db_c->numRows() > 0 ) { while( $data_c = $db_c->fetchArray() ) { ?> <option value="<?php echo $data_c['id'];?>"> <?php echo $data_c['country_name'];?></option> <? }}?> </select> </label> </td> </tr> <?php $state = getState($_SESSION['uid']); ?> <tr> <td align="left"><img src="images/bullete.gif" width="4" height="6" /> </td> <td align="left"><strong>Province/State</strong></td> <td align="left" valign="bottom"> <div id="disstatus"> <select name="region" size="1" class="text_area1" id="region"> <option value="">--SELECT PROVINCE--</option> </select> </div> </label> </td> </tr> <?php $city = getCity($_SESSION['uid']); ?> <tr> <td align="left"><img src="images/bullete.gif" width="4" height="6" /> </td> <td align="left"><span class="wfrmbold">City</span></td> <td align="left"><div id="city_id"> <select name="city" size="1" class="text_area1" id="city" > <option value="">--SELECT CITY--</option> </select> </div></td> </tr>
Código PHP:
function districtstatus($obj,$country)
{
$query_dist1="select * from state_name where country_id='$country' order by state_name";
$fire=mysql_query($query_dist1);
$num=mysql_num_rows($fire);
if($num > 0){
echo "<select name='region' class='a11gray' id='region' onchange='districtstatus1()' >\n";
echo "<option value=''>-SELECT STATE-</option>\n";
while($query_dist11=mysql_fetch_array($fire)){
echo "<option value='".$query_dist11['id']."'>".ucwords($query_dist11['state_name'])."</option>\n";
}}else{
/*original
echo "<select name='region' class='a11gray' id='region' style='width:125px'>\n";
echo "<option value=''>-STATE-</option>\n";
*/
echo '<input type="text" name="region" value="" class="a11gray" id="region" style="width:125px">';
}
}
function districtstatus1($obj,$region)
{
$query_dist2="select * from city_name where state_id='$region' order by city_name";
$fire2=mysql_query($query_dist2);
$num1=mysql_num_rows($fire2);
if($num1>0){
echo "<select name='city' class='a11gray' id='city' onchange='districtstatus2()' >\n";
echo "<option value=''>-SELECT CITY-</option>\n";
while($query_dist22=mysql_fetch_array($fire2)){
echo "<option value=".$query_dist22[id].">".$query_dist22[city_name]."</option>\n";
}}else{
/** original
echo "<select name='state' class='a11gray' id='state' style='width:250px'>\n";
echo "<option value=''>-CITY-</option>\n";
*/
echo '<input type="text" name="state" value="" class="a11gray" id="state" style="width:250px">';
}
}