WordPress.org

Ready to get started?Download WordPress

Forums

Participants Database
Search and sort (12 posts)

  1. Matt
    Member
    Posted 8 months ago #

    I am trying to setup a membership directory that can be searched by category or business name and the resulting list should be sorted by business name.
    Here is the code I am using:
    [pdb_list order="asc" orderby="business_name" search="true" filter="id=0" fields="business_name, business_phone, primary_contact" list_limit="5"]

    When I perform a search the results are the same. The first 5 entries in the database, everytime.

    I think this plugin is fantastic. It has helped me resolve many problems but this is one that has me stumped and as I am not a strong PHP user it makes it difficult for me to understand how to create a custom template if that is what I need to do.

    This is the page where the search is located.
    http://www.westrichlandchamber.org/members-2/

    http://wordpress.org/plugins/participants-database/

  2. xnau
    Member
    Plugin Author

    Posted 8 months ago #

    Seems to be working...did you fix it?

  3. Matt
    Member
    Posted 8 months ago #

    Sorry no. I have not been able to fix it. The search works but it returns the same top five entries regardless of what search terms you use.

  4. xnau
    Member
    Plugin Author

    Posted 8 months ago #

    That wasn't what I found. Try searching for a specific word, like "northwest" in the business name.

  5. Matt
    Member
    Posted 8 months ago #

    OK. That works.
    Category search doesn't seem to work though.

  6. xnau
    Member
    Plugin Author

    Posted 8 months ago #

    OK, well I have no way of testing that, since the categories are not shown. So if you type in the name of a category and hit search, all the records show up?

  7. Matt
    Member
    Posted 8 months ago #

    I have the code set to show 5 records and when you perform a category search it shows the same first 5. It doesn't matter what category I search for. Here is the list of categories.

    Accountants-Certified Public
    Advertising
    Animal Feed
    Assisted Living Facilities
    Associations
    Attorneys
    Auto-Repair
    Bakeries
    Banks
    Baseball
    Beer and Wine Shop
    Beer Wholesaler
    Bookkeeping
    Bowling
    Brewery/Pub
    Buildings - Pole
    Business Lending
    Cable Television
    Candy & Confectionery Retail
    Catering
    Chamber of Commerce
    Chiropractor
    Cleaning
    Collection Agency
    Communications
    Computers/Networks
    Concrete
    Construction
    Consultant
    Contractors
    Convenience Store/Gas Station
    Convention Center
    Copiers & Supplies
    Credit Unions
    Cruises
    Dentists
    Design
    Disaster Restoration
    Distillery
    Economic Development
    Education
    Electric Company
    Electric Utility
    Electronics & Appliance Store
    Employment Services
    Engineering
    Engineering/Environmental Services
    Engravers
    Entertainment
    Environmental Consulting
    Equipment Rentals
    Espresso
    Event Center
    Excavation
    Fence
    Financial Services
    Fire Protection
    Fitness
    Flooring and Countertop Retail
    Food Processing & Manufacturing
    Foods
    Frozen Yogurt
    Funeral Home
    Garage Doors
    Garbage Collection
    Gas distribution - Utility
    Golf Courses
    Graphic Design
    Graphics
    Grocery Store
    Hair/Beauty
    Home Builders
    Hospital
    Insurance
    Interactive Media/Web
    Internet Service Provider
    Investment Services
    Irrigation Products and Services
    Lab & Safety
    Landscaping
    Lawn Care
    Library
    Limousine Service
    Linen Rentals
    Lodging
    Mail & Shipping
    Massage
    Media
    Medical
    Medical Training - Orthopedic
    Metal Fabrication
    Military Surplus
    Mortgages
    Motorcycles
    Municipalities
    Non-profit
    Nutrition
    Office equipment and supplies
    Opticians
    Optometrist
    Packaging & Storage
    Paper
    Paper Shredding
    Pet Grooming
    Pet Treats
    Petroleum Products
    Photographer
    Physical Therapy
    Piano Teacher
    Pizza
    Printing
    Property Management
    Public Power
    Public Transportation
    Publications
    Radio
    Real Estate
    Recreation
    Research & Development
    Restaurant
    Schools
    Second Hand Store
    Seniors
    Service
    Signs
    Silk Screen Printing
    Social Services
    Soft Drink Distributor
    Specialty Foods
    Sporting Goods
    Sports
    Storage
    Surveyor
    Tax Preparation
    Telecommunication
    Television Station
    Tour Bus Services
    Touring
    Tourism
    Travel
    Trophies
    Truck Dealers
    Vacation
    Veterans
    Vineyard
    Waste Removal
    Water Company - Utility
    Wellness Supplements
    Wholesale Warehouse
    Winery
  8. xnau
    Member
    Plugin Author

    Posted 8 months ago #

    Ah, OK. This version of the plugin doesn't search on fields that aren't shown in the list.

  9. Matt
    Member
    Posted 8 months ago #

    I'm not sure what you mean by "aren't shown in the list". If you go to http://www.westrichlandchamber.org/members-2/membership-sign-up/ you can see the signup form and a drop down list for people to select the category that best suits their business.

  10. xnau
    Member
    Plugin Author

    Posted 8 months ago #

    Yes, well the categories aren't visible in the list of businesses. Add that column to your list display and your search will work.

  11. Matt
    Member
    Posted 8 months ago #

    Ah! I didn't realize that was how it had to work. That fixed it.
    Thank you for your assistance and patience.

  12. xnau
    Member
    Plugin Author

    Posted 8 months ago #

    Well, it shouldn't have to be that way, it just is with this version. The next version will give you more freedom with this.

Reply

You must log in to post.

About this Plugin

About this Topic