Webmastersite.net
Register Log In

Search & Refine Sort
How can I refine a sort on the subcategory page

Comments on Search & Refine Sort

Animal
Member

Usergroup: Customer
Joined: Jan 08, 2005

Total Topics: 6
Total Comments: 12
Animal
Posted Feb 28, 2005 - 10:52 AM:

I'm not really sure if I can do this easily with WSN Links or not.

My directory is getting quite large, one subcategory is over 800 listings already, I have asceding or decending custom sorts on company name, city, state etc...

However I would like to refine the state search. With 800 listings an alphabetical listing isn't really much good as the client still has to click on page numbers hoping to get to the page with their own state on it.

I like the refine option on the search listings page, but I can't get it to work on the 'Show Links in Category' page. Plus I don't want to search all listings on the site just those listings in that sub-category...

I've looked in the manual under custom searches and none of these searches seem appropriate for what I'm considering or at least they are not clear to me.. smiling face

So my sort criteria would be search this category for any listings with this state code: (I'm guessing on my form action below could someone help me get it right?) (lstate is the state field in my link database)

<form action="http://mysite.net/dir/search.php?filled=1&condition=and&whichtype=catid" method="post">
<font size="1" face="Verdana, Arial, Helvetica, sans-serif"><b><SPAN class=p>
<select name="lstate" class="body" id="stateselect">
<option value="" selected>Listing by State</option>
<option value="">--------------------------</option>
<option value="AL">Alabama</option>
<option value="AK">Alaska</option>
<option value="AB">Alberta</option>
<option value="AZ">Arizona</option>
<option value="AR">Arkansas</option>
<option value="BC">British Columbia</option>
<option value="CA">California</option>
<option value="CO">Colorado</option>
<option value="CT">Connecticut</option>
<option value="DE">Delaware</option>
<option value="DC">District Of Columbia</option>
<option value="FL">Florida</option>
<option value="GA">Georgia</option>
<option value="HI">Hawaii</option>
<option value="ID">Idaho</option>
<option value="IL">Illinois</option>
<option value="IN">Indiana</option>
<option value="IA">Iowa</option>
<option value="KS">Kansas</option>
<option value="KY">Kentucky</option>
<option value="LA">Louisiana</option>
<option value="MB">Manitoba</option>
<option value="MD">Maryland</option>
<option value="MA">Massachusetts</option>
<option value="ME">Maine</option>
<option value="MI">Michigan</option>
<option value="MN">Minnesota</option>
<option value="MS">Mississippi</option>
<option value="MO">Missouri</option>
<option value="MT">Montana</option>
<option value="NE">Nebraska</option>
<option value="NV">Nevada</option>
<option value="NB">New Brunswick</option>
<option value="NH">New Hampshire</option>
<option value="NJ">New Jersey</option>
<option value="NM">New Mexico</option>
<option value="NY">New York</option>
<option value="NF">Newfoundland</option>
<option value="NC">North Carolina</option>
<option value="ND">North Dakota</option>
<option value="NT">Northwest Territories</option>
<option value="NS">Nova Scotia</option>
<option value="NU">Nunavut</option>
<option value="OH">Ohio</option>
<option value="OK">Oklahoma</option>
<option value="ON">Ontario</option>
<option value="OR">Oregon</option>
<option value="PA">Pennsylvania</option>
<option value="PE">Prince Edward Island</option>
<option value="PR">Puerto Rico</option>
<option value="PQ">Quebec</option>
<option value="RI">Rhode Island</option>
<option value="SK">Saskatchewan</option>
<option value="SC">South Carolina</option>
<option value="SD">South Dakota</option>
<option value="TN">Tennessee</option>
<option value="TX">Texas</option>
<option value="UT">Utah</option>
<option value="VT">Vermont</option>
<option value="VI">Virgin Island</option>
<option value="VA">Virginia</option>
<option value="WA">Washington</option>
<option value="WV">West Virginia</option>
<option value="WI">Wisconsin</option>
<option value="WY">Wyoming</option>
<option value="YT">Yukon Territory</option>
</SELECT>
</SPAN></b></font>
<input type="submit" value="Refine" class="button">
</form>

Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7867
Paul
Posted Feb 28, 2005 - 1:06 PM:

Your form doesn't make any sense. To refine, you need a refine to something (as the input box on the search page does). You haven't specified what to refine to, you've just labeled a regular search as "refine".

Also whichtype=catid is nonsense, see the manual entries on searching which whichtype is explained or just use an example from existing templates.
Animal
Member

Usergroup: Customer
Joined: Jan 08, 2005

Total Topics: 6
Total Comments: 12
Animal
Posted Feb 28, 2005 - 3:51 PM:

You didn't follow my post or maybe I was unclear?

I know my form doesn't make sense, I was trying to give an example, an approximation of where I was trying to lead the answer to.

If I knew what to put there I wouldn't be asking for help... on the support forum...

The refine search form will not work on the listing page. Also there are only 2 whichtype options (all, links). I don't want to search all fields, and i don't want to search all the link fields...

WHAT I NEED: I need to refine within a category.

Can I accomplish this using your program? If so could you post the form code? I'm sure many users who have large databases would be interested in having this added to your online WSN manual as well.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7867
Paul
Posted Feb 28, 2005 - 8:11 PM:

"refine within a category" sounds rather odd, because refinement is for searches. If you really want a search as yu seem to be constructing, first contruct a valid regular search as described in the manual. Then add &refine=term on the url or a hidden input field named refine containing your refinement term.

If you don't really want a search, perhaps you're looking to filter, but since you haven't given any indication of what you're refining to it's impossible to guess if you could filter that way.

I'm guessing from what you've posted so far anyhow that you posted this on the wrong forum. Moving.
Animal
Member

Usergroup: Customer
Joined: Jan 08, 2005

Total Topics: 6
Total Comments: 12
Animal
Posted Mar 01, 2005 - 8:06 AM:

grin
Animal
Member

Usergroup: Customer
Joined: Jan 08, 2005

Total Topics: 6
Total Comments: 12
Animal
Posted Mar 01, 2005 - 8:15 AM:

Animal wrote:
grin


Ahh PERFECT - OK that's exactly what I need.

I need a filter to show only the state selected in a drop down list.

So...someone comes to the website and wants to find a veterinarian. The client is looking for a vet in Mississippi where they live, however there are 800 listings to browse through, after clicking next about 20 times they get to the area they are looking for... and can view the listings in their state.

I've already had a few people asking if there was some way to sort within these sub categories - I'm sure someone on these forums is smart enough to help me figure out how to tweak a search box to allow searches on the state field?

Basically we need to filter the listing results inside the veterinary category by any state that the client could select in a drop-down.

Looks like possibly this link in the manual under Filtering should help thin the listings out! Link is here: scripts.webmastersite.net/w...nks/wsnmanual/articles/201
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.