Incorrect categoryID returned from search

I am using a Data Assist Search Wizard with Data Assist results page.
From the search page I can select a CategoryID number but the results page will only show /Products1/product_results.php?CategoryID=2

IF I select CategoryID 3 or 4 in the search list it always returns the CategoryID=2
I am attaching the Search and Results page.
Can you suggest where I may be incorrect please?
Many thanks
John

your results page is not actually using the data Assist Search, it is just using the URL variable being passed in by the form.

in your serach form you have the action sett to post to the results page, and you are using the recordset to pass the ID:
<form name="form1" action="product_results.php?CategoryID=<?php echo $row_rsCategory['CategoryID']; ?>" method="post">

this ID will always be for the first record.

change the action and the method of the form to not pass the URL in the action, and use the GET MEthod:
<form name="form1" action="product_results.php" method="get">

By using the get method, the form elements will now be passed as the URL variables.

change the name of the select list from Search

<select name="Search">

Search to CategoryID:

<select name="CategoryID">

now the CategoryID URL variable will be controlled by the select list instead of the recordset.

Many thanks Jason for that excellent explanation.

It worked very well.
Regards

John