Hi All, I current have the following code, apologies for the length. I am able to retrieve all the information i require but am looking to include some filter boxes. I have managed to add the filter drop down to the table BUT and am unable to get this to do anything. The dropdown pulls its data from another dedicated table(works) but I need an OnCHANGE event to filter the data where the Country equals the selected record in the dropdown?? (#95 are underscores in the code below) I can manually add the following into the $sql= ... AND Country='BE' and it will find all records for that country.. can this be done dynamically or with a page reload??? Any help gratefully received:

<?php
require './connections/db_connect.php';

$db_name="Projects_Main"; // Database name 
$tbl_name="Main"; // Table name

// Connect to server and select database.
mysql_connect($host, $usrname, $pssword)or die("Connection failed"); 
mysql_select_db($db_name)or die("Connection failed");
$sql=("SELECT * FROM $tbl_name WHERE Status not like 'CLOSED'");
$result=mysql_query($sql);

$num_rows = mysql_num_rows($result);
$fields_num = mysql_num_fields($result);

?>
<table>

<!-- create the table headers and using the next section build the table. sections not shown as page space not sufficent -->
<tr>
    <th>Project ID</th>
    <th>Financial Year</th>
    <th>Country</th>
    <th>More Details</th>
    <th>UPDATE</th>
</tr>
<!--START:filter    NOT WORKING-->
<tr>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th>
        <?php
            $db_name = 'Projects_Main';
            $ctrytable = 'Country';
                if (!mysql_connect($host, $usrname, $pssword))
                       die("Can't connect to database 'cos somethin' is wrong");
                if (!mysql_select_db($db_name))
                     die("Can't select database");
            $result1 = mysql_query("SELECT country_abbrev, country_name FROM {$ctrytable} order by country_name");
            $options="";
        while ($row=mysql_fetch_array($result1)) 
                {
                    $id=$row["country_abbrev"];
                    $thing=$row["country_name"];
                    $options.="<OPTION VALUE=\"$id\">".$id."</option>\n";
                }
        ?>
            <SELECT NAME="Country" type="text" onchange="filterTable(this.options[this.selectedIndex].value);">
                <OPTION VALUE=\"\">ALL
                                        <? echo $options?>
            </SELECT>
    </th>

    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
</tr>
<!--END:  filter -->

    <?php

    while($rows=mysql_fetch_array($result))
    {


    ?>
<!-- echo the contents of database table -->
<tr>
    <td align="center"><?php echo $rows['Project_id']; ?></td>
    <td><?php echo $rows['FinancialYear']; ?></td>
    <td><?php echo $rows['Country']; ?></td> 
    <!-- link to show more info on the record or update record.. -->
    <td><a href="./projects_more.php?Project_id=<?php echo $rows['Project_id']; ?>">more...</a></td>
    <td><a href="./projects_update.php?Project_id=<?php echo $rows['Project_id']; ?>">update</a></td>
</tr>
    <?php
    }
    ?>
</table>

<?php
mysql_close();
?>