Help me with this Idea
I have made a Module for a portal System called xoops , this is my first time to do such thing . any way this Module is to Like Shoutbox But not exactly ShoutBox , its where Visitors Can post Comments On you yours Site ..
I need to make the posted Comment is approved after View it from the Admin.
My idea to do this is , to make a Tabel for approved Message and another for waiting approve.
Ok Now lets Say some 1 posted a Comment then it will be inserted to the waiting approve tabel , and when the admin Sign in and see the waiting message he can click edit and when page open he click Approve where the Message again will be moved from waiting approve tabel to approved Tabel .
IS that the right way to do it or there some other better way .. and so with that idea i have problem that the waiting Approve message stays on the tabel after moving it to approved tabel its like re-sumbit ..
i need it when Moved to the approved tabel to be deleted from waiting Tabel so admin dont approve it agin and agin ..
So any suggetion..