approve submission

[Anon]

ok I create a CMS were a person can add/edit/delete the content of a page.
now I want to make that if a person submits a new entry the content is not directly shown on the "view_result"page, then it should be first approved by the administrator of the page. then he should be able to push a button "approved" and then it's shown on the "view_result" page.

how can I do this? any good tutorials for this?

[mikej]

Pretty simple way would be when you create the content table add a field like APPROVED int(1) then when the content is first created, set it to 0. When it is approved by the administrator set it to 1.

Then when you show results use "Where (APPROVED = '1')" in your SQL statement.

Again, this is a simple solution.

MikeJ