dynamic combobox and mysql

[robert_gsfame]

I have dynamic combobox

 

below is the html code and javascript

function show(){

if (document.form1.country.value == "Brazil"){document.getElementById('city').innerHTML = "<select name='mycity' id='mycity'><option value='ABC' id='ABC'>ABC</option></select>"}

 

<form name="form1" method="post" action="<?php $_SERVER['PHP_SELF'];?>">

<select name="country"><option value="brazil" id="brazil" onchange= onchange="show()">Brazil</option>

 

<div id="city"></div>

<input type="submit" value="submit>

</form>

 

now the problem is when i retrieve the data from mysql database, let say i have ABC already stored in the table (column 'city') then i wish to have it straight away once login...how can i do that as i have used onchange event and that will hide the 2nd combobox if 1st combobox not yet chosen

[o3d]

Just so you know this will create problems if you use the same property in a tag more than once. It uses the first instance and ignore the rest. Remove the first "onchange=" occurance.

<select name="country"><option value="brazil" id="brazil" onchange= onchange="show()">Brazil</option>

 

[robert_gsfame]

i dont really get...could u please be specific :-\

[robert_gsfame]

that is only a mistype anyway

[o3d]

change

<select name="country"><option value="brazil" id="brazil" onchange= onchange="show()">Brazil</option>

to

<select name="country"><option value="brazil" id="brazil" onchange="show()">Brazil</option>

 

btw my suggestion won't fix your problem, i'm just pointing out a problem.

[robert_gsfame]

okay i've change it, but the problem is not yet solved..... :'(

[o3d]

Once the user is logged in, I assume you populate a global variable or a session variable. Say e.g. $_SESSION['city_id']. Then you could do this:

 

<?PHP if ($loggedin) { ?>
<form name="form1" method="post" action="<?php $_SERVER['PHP_SELF'];?>">
<select name="country"><option value="brazil" id="brazil">Brazil</option></select>
<select name="city"><?PHP
//loop through table of cities and check if city id == $_SESSION['city_id']
while () {
	echo '<option value="brazil" id="brazil" '.(city id == $_SESSION['city_id']?'selected':'').'>Brazil</option>';
} ?></select>
<input type="submit" value="submit>
</form>
<?PHP } else { ?>
<script>
function show(){
	if (document.form1.country.value == "Brazil") {
		document.getElementById('city').innerHTML = "<select name='mycity' id='mycity'><option value='ABC' id='ABC'>ABC</option></select>";
	}
}
</script>
<form name="form1" method="post" action="<?php $_SERVER['PHP_SELF'];?>">
<select name="country"><option value="brazil" id="brazil" onchange="show()">Brazil</option>
<div id="city"></div>
<input type="submit" value="submit>
</form>
<?PHP } ?>

 

Please know that this is just a concept and has not been tested and is psuedo-ish. Hope this put you on the right track.

[robert_gsfame]

instead of having the another form, i use body onload=function() ....it works but i think i have to reload the page once form submitted to have the function work

[o3d]

instead of having the another form, i use body onload=function() ....it works but i think i have to reload the page once form submitted to have the function work

 

Yes most definitely.