Filter on recordset and only return those records

Posted on 2011-10-30
Last Modified: 2012-05-12
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!
Question by:palmtreeinfotech
    LVL 21

    Accepted Solution


    Assisted Solution

    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??

    Author Comment

    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.

    Author Closing Comment

    I could not get anyone to respond except one person!

    Author Comment

    Nobody else would respond to my question except one expert.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
    The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now