I am trying to get a dropdown box to choose what is printed out.
The dropdown is populated by course names and when a selection is made I want certain course modules releated to that course printed.

Code to post course name-

?php
          if ( isset( $_POST['send']))
          {
              print_r( $_POST );
          }
      ?>



  <form method='post'>
    <select id="Course_Name" name="Course_Name">
    <?php


       $stmt = $db->prepare('Select Course_Name, CourseID from coursename');
       $stmt->execute();
          while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
       echo '<option>'.$row['Course_Name'].'</option>';
          }
       ?>
   </select> 
 <input type="submit" value="Send" name="send">
 </form>

Code to display modules-

<?php
      require_once('connect.php');
      $sql = "SELECT CourseID, Module_Name,ModuleID, Module_Code, Module_Year  FROM coursemodule ORDER BY ModuleID ASC";
      $stmt = $db->prepare($sql);
      $stmt->bindParam(':ModuleID', $CourseID, PDO::PARAM_INT);
      $stmt->execute();
      while ($output = $stmt->fetch(PDO::FETCH_OBJ)) {
         echo "<p>" . $output->Module_Name  . " " . $output->Module_Code  . "</p>\n";

    }
 ?>

Currently the selection doesn't affect the module output and thats what I am trying to do.
Any help would be appreciated.

still stuck would really apreciate any help.

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.