[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

Filter on recordset and only return those records

What I have is a page basically called "search.php".  It has a dynamic dropdown of names in the database.  I am passing the ID param to another search page called "search1.php".  On that page is a recordset and dynamic table with a master-detail page set.  I have also added an
extension by Tom Muck's dynamic search suite extension.  At first I couldn't get it to filter right but it seems to now after playing with the code.  I just added a $POST[search] to the WHERE statement.

What I CAN'T figure out is once the page is filtered, how do I set the search params to ONLY search for those that are already filtered?

In other words, company = 1 search results company 1, company 1, etc.  When I use the search extension and type in "TEST" it's bringing up company 1, company 2, company 3, etc.

I can paste code of that will help.  I can read code but not really write it.

Thanks to all!
0
palmtreeinfotech
Asked:
palmtreeinfotech
  • 4
2 Solutions
 
palmtreeinfotechAuthor Commented:
Hi Oleggold, thanks for responding.  I looked at some of the posts and not sure which direction to go.  Would it help if I pasted my code??
0
 
palmtreeinfotechAuthor Commented:
Does anyone else have any suggestions for this?  Do you want me to paste the code?  I am using GET now instead of POST but after I add the dynamic SQL the page gets an error.
0
 
palmtreeinfotechAuthor Commented:
I could not get anyone to respond except one person!
0
 
palmtreeinfotechAuthor Commented:
Nobody else would respond to my question except one expert.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now