Approving Pending Data
Posted: Tue Aug 10, 2010 5:49 pm
I wanted to get some input and recommendations on how to go about with this project I have:
I'm setting up a submission-type form for the public to be able to submit their name/info and an image for a contest. This information should also automatically be able to output for others to see who and what has been submitted so far. However, I want to act as the middle man and have to approve of these posts before they go live.
So my initial idea was to create the table with the obvious rows and a boolean-type row for the submission's status.. maybe call it PEND and give it values of YES or NO with NO being the default value when a user submits.
I wanted to see other's input as well as maybe some advice on a different DB and table design.
I'm setting up a submission-type form for the public to be able to submit their name/info and an image for a contest. This information should also automatically be able to output for others to see who and what has been submitted so far. However, I want to act as the middle man and have to approve of these posts before they go live.
So my initial idea was to create the table with the obvious rows and a boolean-type row for the submission's status.. maybe call it PEND and give it values of YES or NO with NO being the default value when a user submits.
I wanted to see other's input as well as maybe some advice on a different DB and table design.