Hi:

First, I really like the versatility of the new search.cgi. Being able to search specific fields is GREAT! Since I have all these fields with info in them (Animators, Directors, Title, Writer, etc), it is great to let people search on those specific fields to find the info they want.

I have made an advanced search page that allows people to search individual fields, so I thought I would share that. Feel free to grab the code and see how I did it, you might find it quite useful. You can preview this search at:

http://www.bcdb.com/bcdb/search.cgi?d=1

OK, this shows how to search individual fields. Anyone know how to search Category Titles only?

Also, Alex (if you are listening...) can we mod search to search the current search results? See, the only way I could make search individual fields work was to search only ONE individual field. I was not able to get this to search where Director = Chuck Jones and Writer = Michael Maltese... so, as an option, I thought it might work to first get all the Chuck Jones films, then search those results for Mike...

dave

Hi,

Why couldn't the multiple work:

http://www.bcdb.com/...h.cgi?Writer=Maltese

returns 139 hits.

http://www.bcdb.com/...h.cgi?Director=Jones

returns 273 hits.

http://www.bcdb.com/...e&Director=Jones

returns 86 hits.

What seems to be wrong?

Cheers,

Alex

ps: congrats on the newborn!

--
Gossamer Threads Inc.

Alex:

Yes, it does work if you WRITE it all out... but I could not find a good way to code it without 50 if...else statements. I mean that when I did try to include all those fields, I got errors, so I simplified each search to one field.

I thpought about a drop down box for the field to search, and do a couple of those, but I could not code that to work.

dave

alex:

What is the search field name I would use to search Category Names specifically?

dave