Show filtered data on database
Show filtered data on database
![jrsalunga](https://secure.gravatar.com/avatar/e6f13cf50ba5eb723796a2f4eb0220b4/?default=https%3A%2F%2Fvanillicon.com%2Fe6f13cf50ba5eb723796a2f4eb0220b4_200.png&rating=g&size=120)
im having this data on database
- ITEM ---------- ONSTOCK
- Pencil ---------- 1
- Paper ---------- 0
what would i configure to the datatables on page so show only the 'pencil' on the page not including the paper?
what configuration on the helper class SPP should I do?
something like 'SELECT item ON products WHERE ONSTOCK = 1'
thanks
This discussion has been closed.