I had a web site ( Real Estate) and visitor can add data. But I only need to add in site only after my approval. So I make a column in database that "approved". When an user submit data then Enter the value "no" in "approved" column. When I approve the post then that will replace to "yes".
And finally The search script in my like as follows
SELECT * from table name where approved='yes';
Please let me know how much this is secure . Or there is any other secure way to do that .
Please help me