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.