Solarpitch Posted October 17, 2006 Share Posted October 17, 2006 Hey guys,I am developing a site that involves user's being able to submit information in the form of an advertisment of a product they want to sell.After the user submits the add I want to be able to moderate all the submitted adds before they get updated in the database!I've thought hard about this but I'am not quite sure where to start, or even how it would be implemented!I'd love some advice, Ger. Quote Link to comment Share on other sites More sharing options...
hostfreak Posted October 17, 2006 Share Posted October 17, 2006 I think the best way to go about it would to create another table that contains all the fields that the main table has (the ones you require). Once a user submits something, insert it into the "pending" table. You could then make a page that calls all entries from that table. Then make another page that allows you to approve or deny etc. If you approve, it will add it to the main table and delete it from the "pending" table. Or if you deny, maybe add in a feature that will have it send a message to them that asks them to contact you for further questioning. Quote Link to comment Share on other sites More sharing options...
LazyJones Posted October 17, 2006 Share Posted October 17, 2006 Or (to save some resources) have a validation field in the table (simple boolean value. 0 for not validated, 1 for validated). Then you could list all not validated adds and update the validation values for those you want. Quote Link to comment Share on other sites More sharing options...
hostfreak Posted October 17, 2006 Share Posted October 17, 2006 ^ah didn't even think about that. Good idea. Quote Link to comment Share on other sites More sharing options...
Solarpitch Posted October 17, 2006 Author Share Posted October 17, 2006 Thanks guys! I cant believe i didnt think of that . . . so simple! Sometimes the answer is right under yout nose! :)Cheers! Quote Link to comment Share on other sites More sharing options...
Solarpitch Posted October 17, 2006 Author Share Posted October 17, 2006 Yup . . I just implemented that and it worked great! Thanks LazyJones . . the validation option was very clever! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.