batch(batch_id,program)
combo2.php
Code: Select all
<form action="combo1.php" method="post">
<select name="uid1"><option >select one</option>
<?php
require_once ('../mysql_connect1.php');
$query = "SELECT batch_id,program from batch";
$result = mysql_query ($query);
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {
echo '<option value="'.$row['batch_id'].'">'.$row['program'].'</option>';
}
mysql_close();
?>
</select>
<input type="submit" value="Show Data!">
</form>student table has user_id,name,batch_id....
combo1.php
Code: Select all
<form action="disstudents.php" method="get">
<select name="uid"><option >select one</option>
<?php
require_once ('../mysql_connect1.php');
$query = "SELECT * FROM students WHERE user_id =". $_GET['uid1']."";
$result = mysql_query ($query);
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {
echo '<option value="'.$row['user_id'].'">'.$row['name'].'</option>';
}
mysql_close();
?>
</select>
<input type="submit" value="Show Data!">
</form>how can i get desired result
any help
(core:combo to combo data pass)
thanks for help