populating one combo box with another in php

[ankitsuhail]

hi
this is my first post in the forum and i got a problem
i am new to php and mysql. now my problem is

i have two list boxes on a form now the first listbox is populated with states from the mysql database now i want that when i change the states in listbox 1 the second listbox should populate with the districts which comes from the database.
and i want it to do without the use of ajax or javascripts because i dont have any knowledge of javascripts. and when i submit the form it takes the script to the next page.

i have populated the first text box but i cant populate the second listbox.

please help

i hope i made my self clear.if not please ask for more clarity
thanks in advance

[NogDog]

Without JavaScript (or AJAX, which is just a particular use of JavaScript), your only option would be to have a form sequence of some sort where the user makes the first selection, then submits that form, which results in a 2nd form with the options populated for the second select element. You could either use hidden form fields or PHP session values in that second form to carry over the inputs from the first form.

[arturoromero]

🆒Hi there , i have recently made something similar of what you need, i hope you can apply it into your code:


<?

$DB = mysql_connect ( "yourserver", "username", "password" ) or die ( 'Error al conectar !!,' . mysql_error () );
mysql_select_db ( "Sepesca01" );

$result1 = mysql_query ( "SELECT * FROM empleados,tablapuente WHERE empleados.CodigoEmpleado = tablapuente.CodigoEmpleado AND tablapuente.CodigoArea = 1", $DB );
$result2 = mysql_query ( "SELECT * FROM empleados,tablapuente WHERE empleados.CodigoEmpleado = tablapuente.CodigoEmpleado AND tablapuente.CodigoArea = 2", $DB );
$result3 = mysql_query ( "SELECT * FROM empleados,tablapuente WHERE empleados.CodigoEmpleado = tablapuente.CodigoEmpleado AND tablapuente.CodigoArea = 3", $DB );
$result4 = mysql_query ( "SELECT * FROM empleados,tablapuente WHERE empleados.CodigoEmpleado = tablapuente.CodigoEmpleado AND tablapuente.CodigoArea = 4", $DB );
?>


var Oficina_del_Titular = new Array(<?
$count = mysql_num_rows ( $result1 );
$count2 = 0;
while ( $res = mysql_fetch_object ( $result1 ) ) {
	$count2 ++;
	?>'<?
	print $res->Empleado;
	?>'<?
	if ($count2 != $count) {
		?>,<?
	}
}
?>);

var Desarrollo_Pesquero = new Array(<?
$count = mysql_num_rows ( $result2 );
$count2 = 0;
while ( $res = mysql_fetch_object ( $result2 ) ) {
	$count2 ++;
	?>'<?
	print $res->Empleado;
	?>'<?
	if ($count2 != $count) {
		?>,<?
	}
}
?>);

var Acuacultura = new Array(<?
$count = mysql_num_rows ( $result3 );
$count2 = 0;
while ( $res = mysql_fetch_object ( $result3 ) ) {
	$count2 ++;
	?>'<?
	print $res->Empleado;
	?>'<?
	if ($count2 != $count) {
		?>,<?
	}
}
?>);

var Cordinacion_Admin = new Array(<?
$count = mysql_num_rows ( $result4 );
$count2 = 0;
while ( $res = mysql_fetch_object ( $result4 ) ) {
	$count2 ++;
	?>'<?
	print $res->Empleado;
	?>'<?
	if ($count2 != $count) {
		?>,<?
	}
}
?>);


switch (Index){
	case "1":
		Arreglo = Oficina_del_Titular;
	break;
	case "2":
		Arreglo = Desarrollo_Pesquero;
	break;
	case "3":
		Arreglo = Acuacultura;
	break;
	case "4":
		Arreglo = Cordinacion_Admin;
	break;

}

for(var l = 0; l < Arreglo.length; l++){

	var objOption = new Option(Arreglo[l], Arreglo[l]);
	document.getElementById('empleado').options.add(objOption);
}

}
</script>[/COLOR]

And then create your boxes:

<select
name="select" id="area" onchange="llena_empleado();">
<option value="0">Seleccione el Area</option>
<option value="1">Oficina del Titular</option>
<option value="2">Desarrollo Pesquero</option>
<option value="3">Acuacultura</option>
<option value="4">Coordinacion Admin</option>
</select></p>
<p class="style18">Seleccione el empleado asignado a la nueva
comision: <select name="empleado" id="empleado">
<option>Seleccione el Empleado</option>
</select></p>

For any further questions just reply my , ill be glad to help you out