Support » Plugin: ABASE » How to use WHERE statement

  • Hi Richard,

    One more question.

    See this shortcode below.

    [abase form=”1,search,” 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.