2 drop down lists and a table on same page (PHP)

Hi
I got 1 static drop down list, 1 dynamic drop down list(shows content of a mysql table) and content of another mysql table on the same webpage. They are all placed on 3 different forms.
The selected option in the first list triggers the 2nd list on the page. However, this works fine.
My problem is that i cannot get the data from the 2nd table displayed once the user has selected a value from the 2nd drop down list.
I know I could try and display the last table on a different page but it all has to be on the same page.
Here's some code:

//first form
<form name="reporttype" method="post" action="report.php?act=submit">
        <label>
         <span class="style16">View report by </span>
         <select name="parameters" id="parameters" class="style16" >
              <option>Client </option>
              <option>Supplier</option>
              <option>URL</option>
         </select>
        </label>
            <p>
              <label>
              <input name="submit" type="submit" id="submit" value="Submit" >
              </label>
        </p>
	  </form>

//2nd form
 <form action="report.php?act=view" method="post" name="textform" class="style16">
       <?php    
        require_once("functions.php");
   	    $connection = db_connect();
	    $suppliers=mysql_query("select * from supplier order by company");
	    $clients=mysql_query("select * from client order by company");
	    $n=mysql_numrows($suppliers);
	    $m=mysql_numrows($clients);
	    //$action = $_GET['act'];  
	    if ($_POST['submit'])
	    { 
		 $option = $_POST['parameters']; 
		 switch ($option) 
		  {
            //default: header("location:report.php"); break;
            case "Client":
			  $label= "Client Company: ";
			  echo $label;
			  echo "<select name=\"parameter\"  id=\"parameter\">";
			    $i=0; 
				while ($i<$m)
				 { $row = mysql_fetch_array($clients);
				   echo "<option value=\"".$row['company']."\">".$row['company']."\n  ";
				   $i++; 
				 }
			  echo " </select>";
			  echo "";
			  echo"<input name=\"view\" type=\"submit\" id=\"view\" value=\"View Reports\">";
			  echo"<input type=\"hidden\" name=\"label\" value=\"".$label."\">";
			  break;
            case "Supplier":
			  $label="Supplier Company: ";
			  echo $label;
			  echo "<select name=\"parameter\"  id=\"parameter\">";
			    $i=0; 
				while ($i<$n)
				 { $row = mysql_fetch_array($suppliers);
				   echo "<option value=\"".$row['company']."\">".$row['company']."\n  ";
				   $i++; 
				 }
			  echo " </select>";
			  echo "";
			  echo"<input name=\"view\" type=\"submit\" id=\"view\" value=\"View Reports\">";
			  echo"<input type=\"hidden\" name=\"label\" value=\"".$label."\">";
			  break;
            case "URL": 
			  $label="URL: ";
			  echo $label;
			  echo "<select name=\"parameter\"  id=\"parameter\">";
			    $i=0; 
				while ($i<$m)
				 { $row = mysql_fetch_array($clients);
				   echo "<option value=\"".$row['url']."\">".$row['url']."\n  ";
				   $i++; 
				 }
			  echo " </select>";
			  
			  echo "";
			  echo"<input name=\"view\" type=\"submit\" id=\"view\" value=\"View Reports\">";
			  echo"<input type=\"hidden\" name=\"label\" value=\"".$label."\">";
			  break;
		
         }	 
		}	
?></p>
      </form>

//3rd form
<?php
	 $action = $_GET['act'];
     if ($action == viewrep)
	 //  if (($_POST['parameter'])&&($_POST['view']))
	   { 
		 $parameter= $_POST['parameter'];
		 echo $parameter;
		 $label=$_POST['label'];
		 switch ($label) 
		 {
          
          case "Client Company: ": 
			  $query=mysql_query("select * from report where companyname='$parameter' and reporttype='client' order by id desc");
	           $n=mysql_numrows($query);
			   echo "<table>"; 
               $i=0; 
		       while ($i<$n)
			    { $row = mysql_fetch_array($query);
			      $r=$row['companyname'];
			      echo"<tr>"; 
                  echo"<td>"; 
                  echo"<a href='reportclient.php\?name=$r'>$r</a\>";
                  echo"</td>"; 
                  echo"</tr>";
			    } 
               echo"</table>";
			   echo"<input name=\"viewrep\" type=\"submit\" id=\"viewrep\" value=\"View Report\">";
    }

		 
} 
 ob_end_flush();
?>
        </span>
            </form>

michelleradu

Junior Poster in Training

55 posts since Dec 2009

Reputation Points: 10

Solved Threads: 5

2 drop down lists and a table on same page (PHP)

This question has already been solved