Approve comments before displaying them. I know most of it but have a question.

I know how to build the form and write the info to the database...and I know how to create a display page to pull the info from the database.  What I would like to have is a page in the middle where the site admin can go in and approve comments/testimonials and they would only show on the display page once they have been approved.

Form page > admin page(post fields to this page in form fields so they can be edited if needed) > approved comments page.

It would probably be nice to have a delete and approve button on the admin page, and I have a good idea of how this can be built, but I am not sure how once something is approved to send it to the display page.  Many sites also use this for comments you may make about a photo or other item, the comments are moderated and then they are displayed after approval.  Any help would be appreciated.

Thank you,
Brad

Hi,

work that way:

- set a value like ''show' to no in the database (default)
- after the data is send to the database send an email to the admin with a link inisde the email use inside the link there is the ID from the record.
- if the admin clicks the link the value for 'show' is set to yes (for the record with this ID)

show only comments (records) on your site where the value of 'show' = yes

Olaf,

Thank you for your reply.  I had thought about sending an email notification when someone submitted a comment, so including a link they can click to activate the comment makes since.  I will try some things out and see what I can come up with.

Thanks!
Brad