How to use (selection) tag with php & mysql?

[web_designer_iq]

Hello..
I have a list of countries and i want to use (selection) tag by automatically.
explain:
the code of list is following:

<option value="40" >Belize</option>
<option value="41" >Benin</option>
<option value="42" >Bermuda</option>
<option value="43" >Bhutan</option>
<option value="44" >Bolivia</option>
<option value="45" >Bosnia and Herzegovina</option>
<option value="46" >Botswana</option>
etc...

If user want to change his information and showing the list of countries, i want to use (selection) tag by automatically of his country (in database).
Thank you

[thorpe]

Sorry you'll need to be a little clearer. What infomation are you trying to display based on a users selection? Is this infomation coming from a database? Have you got any existing code? It might be easier to go from there.

[web_designer_iq]

Yes My dear that's information from database, see the following code:

$DB  = new database_qurey();
$DB->exe_query("SELECT * from countries_list");

echo "<select name=\"country_id\" onchange=\"get_cities()\" class=\"list\">";

while($row = mysql_fetch_assoc($DB->query_result)){
echo "<option value=\"{$row['country_id']}\">{$row['country_name']}</option>";

 }whille
echo "</select>";

[thorpe]

Sorry.. that code creates the form, how do you retrieve the infomation once the user selects an option from the form?

Im still a little lost as to your question. What exactly do you want to do?

[web_designer_iq]

My dear..
I want to (keeping) user country by drop down menu.
example:
If you selected "Australia" from Drop Down Menu , Australia Country will be (selected) by automatically If you want to show your (USER CP) or (User Information).

[HeyRay2]

I'm assuming that your intention is to have a country selected in your country downdown list based on what a user chose previously.

I'll also assume that you are running a query for the current user's information. For our purposes, let's assume that the user ID is 1 in this case. This would produce similar to below:

$DB_user = new database_query(); 
$DB_user->exe_query("SELECT userid, user_name, user_country_id from users WHERE userid = 1");

$user_info = mysql_fetch_assoc($DB_user->query_result);

You would then take the user information and compare it's user_country_id to country_id from your query you used to create your country dropdown list.

The code would look similar to this, adding the code I wrote above:

$DB_user = new database_query(); 
$DB_user->exe_query("SELECT userid, user_name, user_country_id from users WHERE userid = 1");

$user_info = mysql_fetch_assoc($DB_user->query_result);

$DB  = new database_qurey(); 
$DB->exe_query("SELECT * from countries_list"); 

echo "<select name=\"country_id\" onchange=\"get_cities()\" class=\"list\">"; 

while($row = mysql_fetch_assoc($DB->query_result)){
	if( $user_info['user_country_id'] == $row['country_id'] ){
		$selected = "SELECTED";
	} else {
		$selected = "";
	}

echo "<option value=\"{$row['country_id']}\" {$selected}>{$row['country_name']}</option>"; 

}while 

echo "</select>"; 

Let's assume that the user's country was "Bermuda", which was country_id 42. Your select box HTML code would now look like this:

<option value="40" >Belize</option>
<option value="41" >Benin</option>
<option value="42" SELECTED>Bermuda</option>
<option value="43" >Bhutan</option>
<option value="44" >Bolivia</option>
<option value="45" >Bosnia and Herzegovina</option>
<option value="46" >Botswana</option>
etc...

[web_designer_iq]

Great!
Thank you my dear!
That's very good & very easy!