WordPress.org

Ready to get started?Download WordPress

Forums

ABASE
How to use WHERE statement (1 post)

  1. dipeshthetime
    Member
    Posted 4 months ago #

    Hi Richard,

    One more question.

    See this shortcode below.

    [abase form="1,search,http://housenkid.com/search-results/" table="HNKID" columns="ItemName=%ItemName%$Search HousenKid" elements="ItemName" where="Status=1"]

    I am trying to get only the data that has the Status value of 1. Status is a column in my database. Basically I am trying to filter the data where Status is 1. 1 means we have it and -1 means we don't. What am I doing wrong? Thanks.

    https://wordpress.org/plugins/abase/

Reply

You must log in to post.

About this Plugin

About this Topic

Tags