| Re: Filter on recordset and only return those recods [message #175850 is a reply to message #175849] |
Mon, 31 October 2011 02:22  |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma:
|
Senior Member |
|
|
On 10/30/2011 8:52 PM, chrisdavis wrote:
> On Oct 30, 7:52 am, Jerry Stuckle<jstuck...@attglobal.net> wrote:
>> On 10/29/2011 11:02 PM, chrisdavis wrote:
>>
>>
>>
>>> 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!
>>
>> You need to keep track of previous search parameters and include them in
>> your new search.
>>
>
> HI Jerry. That's a good idea but I'm not sure how to do it. Have any
> code suggestions?
How do you keep track of any values between pages? You do this the same
way. It can be in the session, cookies, hidden fields... lots of ways.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]