Please refer to my football recruiting database as reference:
http://www.bruingold.com/cgi-bin/db.cgi?db=recruits99&uid=default&view_search=1

I want the search to return only players in the QB position who either list UCLA as a favorite OR who UCLA is interested in.

In other words, I'd like the query subroutine to first do a "hard" search for QB, then within that subset of QB's perform a "Match Any" search in the 'Favorites' and 'Other interested schools' fields.

Please...please help me with this.

[This message has been edited by fordona (edited March 18, 1999).]

Is this a question that has already been discussed earlier?

From what I've gathered in my limited knowledge of Perl, is that I need to have a two-tiered sub query routine.

I've set up a preliminary search from which I used

push (@subcategory,@values);

In other words, I generated a @subcategory ARRAY which contained all the matched values

Now I wanted to do another iteration of the search routine with:

for (@subcategory) {
@values = $_;
blah..blah...blah....search....;
}

But for some reason the @values array is not separated as I'd hoped. How do I separate the @values arrays from the @subcategory array correctly? Can someone please help? I feel like I'm really close to solving this. I just need a little help.

[This message has been edited by fordona (edited March 19, 1999).]