Can anyone identify what I am doing wrong? Can't display results..

[emilcarlo]

Good Evening,

 

What I am trying to do in here is to display data based on my selected option in the drop down list. I don't have submit button, I just want it to automatically display results based on my selection. Here's my code:

 

<link href="add_client.css" rel="stylesheet" type="text/css">

<?PHP
include("dbconnection.php"); //Include database connection to file

$query = "SELECT * FROM records";

if(isset($_POST["territory"]))

{
	$query .= " WHERE territory LIKE '%".$_POST["territory"]."%' ORDER BY territory ASC LIMIT 0,15"  ;
	$result = mysql_query($query, $connection) or die(mysql_error());

} 



?>

<!-- Start of table -->
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<td>
      <table width="760" border="0" cellpadding="0" cellspacing="0">
        
		<!-- Table data containing the Asia Logo -->
            <td width="199" align="center" valign="top">
                <a href="login.html">
                	<img src="asia.gif" alt="" width="152" height="58" border="0" />
                </a>
            </td>
            <!-- Table data containing Home button -->
            <td width="176" align="right" valign="bottom">
                <a href="main.php">
                	<img src="Home.jpg" width="104" height="20" border="0"/>
                </a>
            </td>
            <!-- Table data containing View Client button -->
            <td width="130" align="right" valign="bottom">
                <img src="View.jpg" width="104" height="20" border="0"/>
            </td>
            <!-- Table data containing the Add Client button -->
            <td width="146" align="right" valign="bottom">
                <a href="add_client.php">
                	<img src="Add.jpg" width="104" height="20" border="0"/>
                </a>
            </td>
            <!-- Blank table data -->
            <td width="109" align="right" valign="bottom"> 
            	
            </td>
        </table>

        <!-- Table design division and body-->
        <table width="760" border="0" cellpadding="0" cellspacing="0">
    		<td width="200" height="3"  bgcolor="#1B1C78">
    			<img src="images/topspacerblue.gif" alt="" width="1" height="3" /></td>
   			<td width="560"  bgcolor="#0076CC">
    			<img src="images/topspacerlblue.gif" alt="" width="1" height="3" /></td>
	    <tr>
	    <td height="500" colspan="2" align="center" valign="top"  bgcolor="#F3FAFE">
            <!-- Page contents -->
            <!-- Search Query -->
            <br>
            <form name="form" action="trustlist.php" method="post">
            <table width="293" border="0">
			<tr>
                    <td width="140" align="left" valign="middle">
                        SEARCH RECORD:
                    </td>
                    <td width="143" align="center" valign="middle"><select name="territory" id="territory" style="width: 143px" width="230">
                      <option selected="selected" disabled="disabled">Select Territory</option>
                      <option>Territory 01</option>
                      <option>Territory 02</option>
                      <option>Territory 03</option>
                      <option>Territory 04</option>
                      <option>Territory 05</option>
                      <option>Territory 06</option>
                      <option>Territory 07</option>
                      <option>Territory 08</option>
                      <option>Territory 09</option>
                      <option>Territory 10</option>
                    </select></td>
                </tr>
		</table>
            <br>
            <!-- End of search query-->
            <!-- Start of Search Results-->			
            <table border="0" cellpadding="3" cellspacing="1" bordercolor="38619E" >
                <tr>
                    <th width="148" align="center" bgcolor="#E0E8F3">Acute Trusts</th>
                    <th width="262" align="center" bgcolor="#E0E8F3">Employer</th>
                    <th width="160" align="center" bgcolor="#E0E8F3">Name</th>
                    <th width="80" align="center" valign="middle" bgcolor="#E0E8F3"> </th>
                </tr>
<?php
if($result)
	{
		for($i=0; $i<mysql_num_rows($result); $i++)
  			{
				$id = trim(mysql_result($result, $i, "id"));
				$territory = trim(mysql_result($result, $i, "territory"));
				$employer = trim(mysql_result($result, $i, "employer"));
				$first_name = trim(mysql_result($result, $i, "first_name"));
				$last_name = trim(mysql_result($result, $i, "last_name"));
					  
				echo "<tr>";
			  	echo "<td>".$territory."</td>";
			  	echo "<td>".$employer."</td>";
			  	echo "<td>".$last_name.", ".$first_name."</td>";
			  	echo "<td><a href='edit_client.php?id=".$id."'>edit</a> | <a href='delete_client.php?id=".$id."'>delete</a></td>";
			  	echo "</tr>";
			}	  
	}  
?>

		</table>
            </form>
            <!-- End of page -->
           	</td>
          </tr>
        </table>
</td>
<tr>
    	<td height="38">
        	<table width="760" border="0" cellpadding="0" cellspacing="0">      
        		<td width="200" height="35" align="center"  bgcolor="#1B1C78" class=white>
        			<a href="disclaimer.html">
            			<font color="#FFFFFF">Legal Disclaimer</font>
            		</a>
        		</td>
        		<td width="560" align="center"  bgcolor="#0076CC">
        			Copyright © 2006 - 2010 AsiaLimited. All rights reserved.
        		</td>
	</table></td>
</tr>
</table>

[Pikachu2000]

You'll need to look into using AJAX for that.