So I still haven't found a solution. In a post of the last few weeks I found something about the same search as in the admin center. That's what I am looking for too, I realise now. But... I am not working with templates, but the site_html.pl

So basically, what I want the Advanced Searched Form on the site (meant for visitors) to do is the following:

Query = ER (i.e. the name of the fandom / television series)

Then the possibility to choose to only look in the field Fandom (like you can in the admincenter, fandom is one of the fields in my database).

Then have the results displayed with only links with the fandom ER. And not also all the categories with the mentioning of er in the name of the category, like Buffy The Vampire Slayer. Is there anyone who can help me with this? It's been a half year now, and I still haven;t found a solution...........

My admin center gives me the following form:

ACS Fanfiction Portal Database: Search the Database

Search the Database


ID:

Title:

URL:

Date:

Category: (Just think a big list with categories)

Description:

Contact Name:

Contact Email:

Fandom:

Fanficrating:

Personalpage:

Pairing:

Genre:

Maincharacter:

Language:

Hits:

isNew:

isPopular:

Rating:

Votes:

ReceiveMail:


Search Options:
Match Any Match Case Whole Words Reg. Expression
Keyword Search (will match against all fields)
Max. Returned Hits
Sort By: ---ID Title URL Date Category Description Contact Name Contact Email Fandom Fanficrating Personalpage Pairing Genre Maincharacter Language Hits isNew isPopular Rating Votes ReceiveMail Sort Order: AscendingDescending

Link: Add View Delete Modify List All

The links in the database are displayed in the admincenter as followed:

ID: 60

Title: The Lounge

URL: http://www.neoxer.com/fic.html

Date: 28-May-2002

Category: one_series_sites/d_g/er/g-a-s

Description: An ER fansite with fanfiction of all sorts. Ranges from angst to slash, episodic to epic.

Fandom: ER

Fanficrating: all

Personalpage: No

Pairing:

Genre: General-Adult-Slash

Maincharacter:

Language:

Hits: 110

isNew: No

isPopular: No

Rating: 9.61

Votes: 76

ReceiveMail: Yes



Here you can see that Fandom is one the fields, just like URL, etc. I want visitors to be able to search the fields:

• title
• URL
• Description
• Fandom
• Fanficrating
• Pairing
• Genre
• Maincharacter
• Language

Since I can do this from the admincenter, I'd like visitors to have the option to do the same from the Advanced Search Form.



I hope one of you can help me now.



Regards,

Ilse