Support » Plugins and Hacks » How to use WHERE statement

How to use WHERE statement

  • dipeshthetime


    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.


  • The topic ‘How to use WHERE statement’ is closed to new replies.