Hi John,
Personally, I'd have a StatusFlag on my Link Table. Let people submit
links directly to the Links table and set the StatusFlag to 0,
(Pending). Create yourself a password protected admin script that let's
you update the StatusFlag, then once the Links have been approved, set the
StatusFlag to 1 (Ok). The page on your site that lists the links then
only needs to query the records that have a StatusFlag = 1.
HTHAL
Nick
At 06:42 15/05/00 -0500, you wrote:
>I accept submissions for links to be listed on one of my sites.
>Originally, this was merely by E-mail. Then I set up a form, so I could
>get as many fields filled in as possible and save some research time.
>The form generated an E-mail to me and the sender.
>
>Now, I'd like to have submitters enter the info directly in my database.
>Should I let them enter it in my main tables, or should I create
>separate tables and, once I approve the submissions, copy them to the
>main tables?
>
>If I do it the first way, I'd need to set up a flag to allow display,
>once I've approved the submission. Any thoughts on the best way to do
>this?
>
>TIA,
>--John Allred
>
>
>--
>John Allred / Jackson, Mississippi
>Webmaster, Mississippi Counties
>http://www.mscounties.com/
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
