Page 1 of 1

Authorizing submitted forms

Posted: Mon Jun 06, 2005 1:05 am
by morris_osu
Okay, I'm not sure if this question has been asked yet, so I'll just ask it on here.

What I want to do is have a form in which users can submit data. Then, I want that data to be stored in a database (an un-authorized database). Then, on an admin-only page, I want the un-authorized data listed and the ability to authorize them by a mere click of a button, thereby adding them to an authorized database. This information will then be posted online.

Sound easy? I'm having trouble with the authorization part of the entire thing. Would it be easiest to just have another form, have the un-authorized data listed, and when a certain one is selected (from a drop-down menu, probably), to just have the submit button put it in the authorized database? Or would there be an easier way, maybe? Thanks!

Posted: Mon Jun 06, 2005 1:08 am
by thegreatone2176
i think it would be easier to just use one table and then have a column for 'authorized' and when its first submitted set it to 0 then after you do your admin function have it update that column to 1

using two would be a big waste of time/space/code

Posted: Mon Jun 06, 2005 1:09 am
by morris_osu
Ah, good call. It's late, LOL.