Well, I guess I'm partly right. Even if I forget little things like closing parentheses!
The reason I asked about the number of searches returned, specifically from your "What's open now" thing is that we're going to have to fudge the search a bit. If I understand what you want correctly, you want to return records that match
city + office open time + office close time
or
city + hotline open time + hotline close time
The way the script is set up, you can't mix "ands" and "ors." So we have to fudge it. We can do a search for the offices being open and then tack on the results of a search for the hotlines being open. But it's all got to be on one page or it won't work.
Regular searches are not a problem. It's just the "What's open now" thing that's the problem.
JPD
http://www.jpdeni.com/dbman/
The reason I asked about the number of searches returned, specifically from your "What's open now" thing is that we're going to have to fudge the search a bit. If I understand what you want correctly, you want to return records that match
city + office open time + office close time
or
city + hotline open time + hotline close time
The way the script is set up, you can't mix "ands" and "ors." So we have to fudge it. We can do a search for the offices being open and then tack on the results of a search for the hotlines being open. But it's all got to be on one page or it won't work.
Regular searches are not a problem. It's just the "What's open now" thing that's the problem.
JPD
http://www.jpdeni.com/dbman/