Search results displays all records

Hello all,

I've been working on a search and results page for some time now. I used data assist to create the admin back end of a photo gallery system.

My trouble is, by using the data search behavior I only display all records from within my database.

I'm fairly confident that the problem is with the value that I'm trying to use for the filter in the search parameter setup.

Attached are my search and results pages.

Thanks for any help.

Instead of using server values like:

$_GET[S_subCategory]

you should be entering them like:

<?php echo($_GET['S_subCategory']); ?>

Yeah, I had something similar to that before, by using the lightning bolt and selecting the form fields.

But, neither of those worked.

I do know that if I setup the recordset with the same filters it works, but I was looking for a more "guided" setup. Also I'm not sure how to search text with using the advanced recordset setup.

Again thanks for the help.

Can I see an updated zip of the pages with the correct syntax as I suggested. I can take a look and see what else might be wrong.

Here are the updated files.

I see it added the "()" around my variables, not sure if that helps.

The results page still isn't updated.

The code:

//comparison list additions
  $WADbSearch1->addComparison("subCategory","$_GET[S_subCategory]","AND","=",1);
  $WADbSearch1->addComparison("favorite","$_GET[S_favorite]","AND",">=",1);
  $WADbSearch1->keywordComparison($KeyArr1,"$_GET[S_department_name]","AND","Includes",",%20","%20","%22","%22",0);

will become:

//comparison list additions
  $WADbSearch1->addComparison("subCategory","". $_GET['S_subCategory'].  "","AND","=",1);
  $WADbSearch1->addComparison("favorite","". $_GET['S_favorite'].  "","AND",">=",1);
  $WADbSearch1->keywordComparison($KeyArr1,"". $_GET['S_department_name'].  "","AND","Includes",",%20","%20","%22","%22",0);

I don't know why it wasn't updated.

I attached the files again in a new name.

I also tried hand coding the filter as you posted with the same results, and I also changed the subCategory value to the form field selection as a trial. Again all with the same result, all records are displayed.

The search is never running since you are using a form method="get" and have your trigger set to $_POST.

Try updating your trigger code from:

if (isset($_POST["Search_x"])) {

to:

if (isset($_GET["Search_x"])) {

Well that did it.

I knew it was using GET but when using DataAssist there is no way to change that setting, I had to hand code it. Could that be a bug? Maybe have the choice of POST or GET?

Thank you for your help, I always get fast and accurate help.