Silly question from a beginner, using phpMyAdmin.

I'm using PHP and MySQL to develop my personal blog. One of the features is a comments table in the blog database, so that visiters record their comments on a form, and the form data is inserted into the comments table as a new row. And obviously, comments are retreived and displayed via a SELECT SQL query.

What's missing is a method for me to approve comments before they are made public. How do I go about this? I'm sure there must be a quick method but can't work out what it would involve.

Any assistance much appreciated :)

hai,
add a new filed call status in the same table, by default put the value as 0,
in selection condition select * from tablename where status = 1, if you approve comments put the status as 1, hope it will help you.


surendran
(Anything is Possible)
http://ssuren.spaces.msn.com

Thank you for this advice, I will give it a go!