i am doing select the data that you want ,then it will search the data in another drop-down list then to search the result~ but it cannot work ,,,can help me

<option value="0">-SELECT PROGRAM-</option>
          <?php require_once('../../../Connections/admin_db.php');
    

            $q = "SELECT p_id,p_name FROM p_reg ORDER BY p_id asc" ;
            $res = mysql_query($q) ;
                                                        
           if (mysql_num_rows($res) == 0) echo "<option>Please Register Level</option>" ;
                                                        
                  while($row = mysql_fetch_array($res))
                      {
                         $p_id = $row['p_id'] ;
                         $p_name = $row['p_name'] ;
                                                            
        if($_REQUEST['prog'] == $p_id) echo "<option selected value='$p_id'>$p_id - $p_name</option>" ;
            else echo "<option value='$p_id'>$p_id - $p_name</option>" ;
             }	
						?>
                    <?
             
if ($_REQUEST['Submit'] && $_REQUEST['prog'] != "0")
					{
	$p_id = $_REQUEST['prog'] ;
				?>
         </select></td>
                <td width="12%" align="right"><strong>COURSE :</strong></td>
		<td width="39%" align="left">               
<select name="course" id="course" onChange="location = 'test.php?Submit=Program&amp;Submit2=Course&amp;prog=<? echo $p_id ?>&amp;course=' + this.options[this.selectedIndex ].value;">
  <option value="0">-SELECT COURSE-</option>
						
	<?php
	$q = "SELECT c_id,c_name FROM c_register WHERE p_id='$p_id' ORDER BY c_id asc" ;
         $res = mysql_query($q) ;
																						       if (mysql_num_rows($res) == 0) echo "<option>Please Register Level</option>" ;
											while($row = mysql_fetch_array($res))
{
$c_id = $row['c_id'] ;
$c_name = $row['c_name'] ;
																					if($_REQUEST['course'] == $c_id) echo "<option selected value='$c_id'>$c_id - $c_name</option>" ;
else echo "<option value='$c_id'>$c_id - $c_name</option>" ;
		}														
	?>
	</select></td>
                <?
}?>

That I want? .. What is the problem exactly in order to help you fix it?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.