[ic] Filtering through a MySQL Field

[Jim Webster]

Hello,

On my results page I'd like to only show records which have been approved.

Example:
I have a table in my database called 'members'.  In this table is a field
called 'member_approved'.  Default value is set to '0'.  When performing
searches, I need my results page to only show records which are set to '1'
in the 'member_approved' field.

In my results page, I have tryed:
[if item-data members member_approved=1 then]

This does not work, any ideas?

Jim