I am useing DWMX/PHP/MySQL
i have dynamic list/menu and and results page i can not get to work here is link www.simssurplus.com/simssurplus/

I did this on diffrent site and it works fine here is link www.simssurplus.com/chapman

Bin trying to fix this for a week now have no idea what the problum is Please Help
Here is the code for the 2 pages i am useing

<b>List/Menu Page</b>

&lt;?php require_once('Connections/SimsSurplus.php'); ?&gt;
&lt;?php
mysql_select_db($database_SimsSurplus, $SimsSurplus);
$query_Recordset1 = "SELECT * FROM equipmentcatagory";
$Recordset1 = mysql_query($query_Recordset1, $SimsSurplus) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?&gt;

&lt;html&gt;
&lt;head&gt;
&lt;title&gt;Sims Surplus&lt;/title&gt;
&lt;meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"&gt;
&lt;/head&gt;

&lt;body&gt;
&lt;form action="results.php" name="Catagory" id="Catagory"&gt;
&lt;div align="center"&gt;
&lt;select name="CatagoryName" size="12" id="CatagoryName"&gt;
&lt;?php
do {
?&gt;
&lt;option value="&lt;?php echo $row_Recordset1['CatagoryName']?&gt;"&gt;&lt;?php echo $row_Recordset1['CatagoryName']?&gt;&lt;/option&gt;
&lt;?php
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
$rows = mysql_num_rows($Recordset1);
if($rows &gt; 0) {
mysql_data_seek($Recordset1, 0);
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
?&gt;
&lt;/select&gt;
&lt;br&gt;
&lt;input type="submit" name="Submit" value="Submit"&gt;
&lt;/div&gt;
&lt;/form&gt;
&lt;/body&gt;
&lt;/html&gt;
&lt;?php
mysql_free_result($Recordset1);
?&gt;

<b>Results Page</b>

&lt;?php require_once('Connections/SimsSurplus.php'); ?&gt;
&lt;?php
$colname_Recordset1 = "-1";
if (isset($HTTP_GET_VARS['equipmentcatagory'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['equipmentcatagory'] : addslashes($HTTP_GET_VARS['equipmentcatagory']);
}
mysql_select_db($database_SimsSurplus, $SimsSurplus);
$query_Recordset1 = sprintf("SELECT * FROM equipmentlist WHERE Catagory = '%s'", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $SimsSurplus) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?&gt;
&lt;html&gt;
&lt;head&gt;
&lt;title&gt;Sims Surplus&lt;/title&gt;
&lt;meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"&gt;
&lt;/head&gt;

&lt;body&gt;
&lt;form name="form1" method="post" action=""&gt;
&lt;table width="75%" border="1"&gt;
&lt;tr&gt;
&lt;td&gt;&lt;div align="center"&gt;&lt;strong&gt;QTY&lt;/strong&gt;&lt;/div&gt;&lt;/td&gt;
&lt;td&gt;&lt;div align="center"&gt;&lt;strong&gt;Manufacture&lt;/strong&gt;&lt;/div&gt;&lt;/td&gt;
&lt;td&gt;&lt;div align="center"&gt;&lt;strong&gt;Catagory&lt;/strong&gt;&lt;/div&gt;&lt;/td&gt;
&lt;td&gt;&lt;div align="center"&gt;&lt;strong&gt;Catalog Number&lt;/strong&gt;&lt;/div&gt;&lt;/td&gt;
&lt;td&gt;&lt;div align="center"&gt;&lt;strong&gt;Discription&lt;/strong&gt;&lt;/div&gt;&lt;/td&gt;
&lt;td&gt;&lt;div align="center"&gt;&lt;strong&gt;Condition&lt;/strong&gt;&lt;/div&gt;&lt;/td&gt;
&lt;td&gt;&lt;div align="center"&gt;&lt;strong&gt;Picture 1&lt;/strong&gt;&lt;/div&gt;&lt;/td&gt;
&lt;td&gt;&lt;div align="center"&gt;&lt;strong&gt;Picture 2&lt;/strong&gt;&lt;/div&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;?php do { ?&gt;
&lt;tr&gt;
&lt;td&gt;&lt;?php echo $row_Recordset1['QTY']; ?&gt;&lt;/td&gt;
&lt;td&gt;&lt;?php echo $row_Recordset1['Manufacture']; ?&gt;&lt;/td&gt;
&lt;td&gt;&lt;?php echo $row_Recordset1['Catagory']; ?&gt;&lt;/td&gt;
&lt;td&gt;&lt;?php echo $row_Recordset1['CatalogNumber']; ?&gt;&lt;/td&gt;
&lt;td&gt;&lt;?php echo $row_Recordset1['Discription']; ?&gt;&lt;/td&gt;
&lt;td&gt;&lt;?php echo $row_Recordset1['Condition']; ?&gt;&lt;/td&gt;
&lt;td&gt;&lt;img src="&lt;?php echo $row_Recordset1['Picture1']; ?&gt;" width="32" height="32"&gt;&lt;/td&gt;
&lt;td&gt;&lt;img src="&lt;?php echo $row_Recordset1['Picture2']; ?&gt;" width="32" height="32"&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?&gt;
&lt;/table&gt;
&lt;/form&gt;
&lt;/body&gt;
&lt;/html&gt;
&lt;?php
mysql_free_result($Recordset1);
?&gt;

I fix my problum i set filter to table collum name it should have ben form name lol