Ready to get started?Download WordPress


Search (2 posts)

  1. brandon.amey
    Posted 2 months 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 1 month 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 :)


You must log in to post.

About this Plugin

About this Topic