Search (2 posts)

  1. brandon.amey
    Posted 2 years ago #

    I've installed the plugin, but I am a newbie to mysql. I'm using the search functionality. The user types in a part number and all the records with that part number should show in the search results.

    Here is the short code that I've used where the form is located:
    [abase table="calls" form="1,search,/part-search/" table="Search" columns="Part Number$Search For A Part" elements="Part Number,Manufacturer,Stock,Buy Now"]

    Here is the short code that I've used where the results are located:
    [abase table="Search" columns="Part Number,Manufacturer,Stock,Buy Now" echo="0" ack="green" limit="30"]

    Everything works properly until the actual search. If I type in a part number, the entire table shows up. How do I make it show only the relevant rows to the search. I'm also new to support so if there is any other information that I need to provide, let me know and I'll definitely provide it. Any help is more than appreciated.


  2. hadnan
    Posted 2 years ago #

    where is your condition in the results page? .. you should add the statues tag to the results page as following

    [abase table="Search" columns="Part Number,Manufacturer,Stock,Buy Now" where="AND status='1'"echo="0" ack="green" limit="30"]

    hope this works for you :)

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic