Hi again

is there any way to avoid to have all the countries listed in a Action Form, making it such way to make appear automatically the countries i a action form when a specific cuntry is introduced is in a data base?

In another words, I do not need to have all the countries listed previously. Only appear the country(ies) when the user(s) fill up a form and intruduce is contry in data base.

Thanks

Yes. ..

Originally Posted by chrishirst

Yes. ..

Well.... How to do it then?

Can you tell me where can I found a code for it?

thanks

http://www.webmaster-talk.com/php-fo...ith-mysql.html

It's simply a matter of reading the data with a query then writing it out into <option> elements with a "for each" or a "while" loop.

Originally Posted by chrishirst

http://www.webmaster-talk.com/php-fo...ith-mysql.html

It's simply a matter of reading the data with a query then writing it out into <option> elements with a "for each" or a "while" loop.

Hi

Thanks

I will give it a try.

see you

Originally Posted by josil

Hi

Thanks

I will give it a try.

see you

I just trying but....

Here it is the original form:

 
<form action="search.php" method="post" enctype="application/x-www-form-urlencoded" name="salerent;
     <select name="rentalperiod" class="salerent" id="rentalperiod">
       <option value="0">Select business type</option>
       <option value="rent"<? if ($rentalperiod == "rent") echo"selected"; ?>>Property for rent</option>
       <option value="sale"<? if ($rentalperiod == "sale") echo"selected"; ?>>Property for sale</option>
     </select>
     
     <select name="countrylet" class="salerent">
        <option value=""<? if($countrylet == "") echo"selected"; ?>>All countries</option>
                    <option value='Acapulco'<? if($countrylet == "Acapulco") echo"selected"; ?>>Acapulco</option>
                    <option value='Afghanistan'<? if($countrylet == "Afghanistan") echo"selected"; ?>>Afghanistan</option>
                    <option value='Albania'<? if($countrylet == "Albania") echo"selected"; ?>>Albania</option>
                    <option value='Algeria'<? if($countrylet == "Algeria") echo"selected"; ?>>Algeria</option>
                    <option value='American Samoa'<? if($countrylet == "American Samoa") echo"selected"; ?>>American Samoa</option>
 
bala...bla...
 
<input name="Submit" type="submit" class="salerent" value="Search">
                  <input name="ord" type="hidden" id="ord" value="id">
                  <input name="ord2" type="hidden" id="ord2" value="asc">
              </form>

taking your example i did:



<form action="search.php" method="post" enctype="application/x-www-form-urlencoded" name="salerent;
<select name="rentalperiod" class="salerent" id="rentalperiod">

<?
while($queryIds->fetchInto($queryId))
{
$id=$queryId["salerent"];
$name=$queryId["countrylet"]." ".$queryId['country'];
$options.="<OPTION VALUE=\"$id\">".$name."</OPTION>";
} // Ene of while
echo "<SELECT NAME='person'>".$options."</SELECT>"; ?>


<option value="0">Select business type</option>
<option value="rent"<? if ($rentalperiod == "rent") echo"selected"; ?>>Property for rent</option>
<option value="sale"<? if ($rentalperiod == "sale") echo"selected"; ?>>Property for sale</option>
</select>

<select name="countrylet" class="salerent">
<option value=""<? if($countrylet == "") echo"selected"; ?>>All countries</option>
<option value='Acapulco'<? if($countrylet == "Acapulco") echo"selected"; ?>>Acapulco</option>
<option value='Afghanistan'<? if($countrylet == "Afghanistan") echo"selected"; ?>>Afghanistan</option>
<option value='Albania'<? if($countrylet == "Albania") echo"selected"; ?>>Albania</option>
<option value='Algeria'<? if($countrylet == "Algeria") echo"selected"; ?>>Algeria</option>
<option value='American Samoa'<? if($countrylet == "American Samoa") echo"selected"; ?>>American Samoa</option>

bala...bla...

<input name="Submit" type="submit" class="salerent" value="Search">
<input name="ord" type="hidden" id="ord" value="id">
<input name="ord2" type="hidden" id="ord2" value="asc">
</form>

[/CODE]