This topic is locked
[SOLVED]

 Pending data list

3/18/2009 9:00:35 AM
PHPRunner General questions
W
wilsonhaze author

Hi Jane,

I posted a previous thread about pending data, so i followed your response to do the following;
Before record added event on the Events tab

$values["status"] = "not approved";
after i did this, the record still shows in the database,

how do i make this record invisible until it the admin clicks something like an approve button.
Thank you.

Sergey Kornilov admin 3/18/2009

Add a WHERE clause to SQL Query i.e.
select ...

from ...

WHERE status<>'not approved'
In this case not approved records won't be displayed on the list page.