Search from a dynamic dropdowns form.

Hi,

Attached is the search form and the search results pages plus an sql database should you need it.

The result of this is that the results page just shows an empty table (no result) and I cannot figure out why. Can you tell me where I'm going wrong here?

Many thanks.

in the Create Dynamic Array behavior, set the Child ID Column to be the GroupLocator instead of Group ID column

Well I would never have thought of that in a million years.

Many, many thanks as always Jason.

The way i figured that was to look at the recordset code. This line:

$rsGroupsSearch = mysql_query($query_rsGroupsSearch, $connCvmOrg) or die(mysql_error());

executes the query. the first argument:
$query_rsGroupsSearch

is the SQL string.

In the body of the page, I added the following code:

SQL: <?php echo($query_rsGroupsSearch); ?><br />

POST: <?php var_dump($_POST); ?>

to see both the SQL being executed on the database and the contents of the form post.

the result was:

SQL: SELECT * FROM groups WHERE (Region = 2) AND ((GroupLocator LIKE '%2%')) 
POST: array(4) { ["sel_region"]=> string(1) "2" ["sel_location"]=> string(1) "2" ["search"]=> string(6) "Search" ["WADbSearch1"]=> string(6) "Submit" }

I could see from this part of the SQL:
GroupLocator LIKE '%2%'

that the value being used for the GroupLocator comparison was the Group ID value, not GroupLocator value.
the string

Well thanks for the explanation Jason. Once again you lot go that extra mile.

I don't pretend to understand fully but I will study that at my leisure and try and get my head round it.

You're welcome, I prefer the "teach a man to fish" method rather than just catching 'em for you.

Good philosophy :-)