Listbox value in where clause

Hi,

I have used DA to set up my results page as normal. Now I want to do this:

I have a start.html
On that page is a list box that grabs and groups data from one field in my database so I have a list. The list box is named SelectTech. This is working fine

On the results.html I want to add the listbox value to my where clause. The page comes up but with no data, but in the URL I can see the value
ww.mysite.com/drill/Tdrill_ResultsDynamic.php?SelectTech=1&TechButton=Submit

SelectTech= 1

In this case, 1 should be whats in the where clause. It doesn't seem to be pulling only the 1 out.

Thanks

On the results page, edit the reocrdset.


In the filtering section, select the column you wish to filter, set it to a Query Sting variable and enter the name:
SelectTech

Thanks for the help.

I tried adding it a variable and am now getting the error message: Parse error: syntax error, unexpected '=', expecting ',' or ')' in . . . line 98

which is

$SelectTech_WADATdrill = (get_magic_quotes_gpc()) ? #SelectTech# : addslashes(#SelectTech#);

The URL is:
start.php

use the drop down list.

can you send a screen shot showing how you configured this in the recordset dialog box?

Here you go. Also a strange thing. In the SQL the SelectTech in the where clause keeps changing to SELECT Tech

1) In the where clause you have:

WHERE Tdril.techid = SELECT Tech

this is wrong for 2 reasons: a) you cannot use the sql keyword "SELECT" in the where clause and b) The actual name of the parameter is "SelectTech"

the where clause should be:

WHERE Tdril.techid = SelectTech

2) for the runtime value of the SelectTech parameter, you entered:
#SelectTech#


this is not a valid php variable. the run time value should be:
$_GET['SelectTech']

That was it. Thanks very much!

you're welcome.