I have done that (well, at least think I have done it) but the dropdown when filtered doesnt show which item it is filtered by
the code I have added is:
<?php
@session_start();
if(isset($_POST["WADbSearch1"])) {
$_SESSION["filterbycategory"] = "".$row_WADAsponsors['SponsorCategoryID'] ."";
}
?>
and
<table cellpadding="2" cellspacing="5" border="0">
<tr>
<td colspan="3"><h1>Filter Sponsors by category: </h1></td>
</tr>
<tr>
<td colspan="3"><select name="sponsorSearch">
<?php do { ?>
<option value="<?php echo $row_Categories['CategoryID']; ?>" selected="selected" <?php if (!(strcmp($row_WADAsponsors['SponsorID'],$row_Categories['CategoryID']))) {echo "selected=\"selected\"";} ?> <?php if (!(strcmp($row_Categories['CategoryID'], $row_WADAsponsors['SponsorCategoryID']))) {echo "selected=\"selected\"";} ?>><?php echo $row_Categories['CategoryName']; ?></option>
<?php } while ($row_Categories = mysql_fetch_assoc($Categories)); ?>
</select></td>
</tr>
<tr>
<td width="60"><input type="submit" class="btn" name="WADbSearch1" value="Submit" style="width: 90px;" />
<td width="96"><input name="SearchReset" class="btn" type="button" onclick="window.location.href='sponsor_results.php?reset=true'" value="Reset" style="width: 90px;" />
</tr>
</table>