View difference between Paste ID: m60qNa1m and vPXfCzpk
SHOW: | | - or go back to the newest paste.
1
<select name="cc">
2
	<?php display_countries(""); ?>	
3
</select>
4
5
// Call `display_countries` with empty string to all countries
6
// Call `display_countries($country_id)` then option will displayed as selected.
7
8
9
<?php
10
11
function display_countries($country_id) {
12
13
	// write your query
14
	$query = "SELECT country_id, country_name FROM Countries";
15
	
16
	// now run your query with connection or link 
17
	$run_query = $link->query($query);
18
19
	// here option will be display and we will stored and get it from the array
20-
	while ($r = $link->fetch_array(MYSQL_BOTH)) {
20+
	while ($r = $run_query->fetch_array(MYSQL_BOTH)) {
21
22
		$is_selected = "";	// first is_selected to empty
23
		if ($r['country_id'] == $country_id) {
24
			$is_selected = "selected"; // $country_id is equal to id from the database then its a selected option
25
		}
26
		
27
		// print the required option for selected with $is_selected variable
28
		// $r['country_id'] and $r['country_name'] are the column name from database
29
		echo "<option value='" . $r['country_id'] . " $is_selected '>" . $r['country_name'] . "</option>";
30
		
31
32
	}
33
34
35
}