468,248 Members | 1,459 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,248 developers. It's quick & easy.

Simple PHP approve/deny

Here's what I want to do
I have a form on my site that lets people add a word and then submit
it. It gets submitted to a secondary database. I would then go to the
script and it would show all the words that were added and I could
approve or deny. By approving it would copy that specific row in the
secondary db to the primary which shows on the site live and by
denying it would keep it in the secondary (to prevent duplicates) and
remove it from the script approve/deny page.

I hope this all makes sense.

Thanks in advance,
Bryan
Sep 20 '08 #1
4 1971
On 20 Sep, 21:20, Igoogler <Galat...@gmail.comwrote:
Here's what I want to do
I have a form on my site that lets people add a word and then submit
it. It gets submitted to a secondary database. I would then go to the
script and it would show all the words that were added and I could
approve or deny. By approving it would copy that specific row in the
secondary db to the primary which shows on the site live and by
denying it would keep it in the secondary (to prevent duplicates) and
remove it from the script approve/deny page.

I hope this all makes sense.

Thanks in advance,
Bryan
Why not just have one table with an "approved" column. When the word
gets written to the table, the approved column is blank, when you
approve it, put a 1 in.

The query to display words will only display those with a 1 in the
approved column.
Sep 20 '08 #2
On Sep 20, 1:24*pm, Captain Paralytic <paul_laut...@yahoo.comwrote:
On 20 Sep, 21:20, Igoogler <Galat...@gmail.comwrote:
Here's what I want to do
I have a form on my site that lets people add a word and then submit
it. It gets submitted to a secondary database. I would then go to the
script and it would show all the words that were added and I could
approve or deny. By approving it would copy that specific row in the
secondary db to the primary which shows on the site live and by
denying it would keep it in the secondary (to prevent duplicates) and
remove it from the script approve/deny page.
I hope this all makes sense.
Thanks in advance,
Bryan

Why not just have one table with an "approved" column. When the word
gets written to the table, the approved column is blank, when you
approve it, put a 1 in.

The query to display words will only display those with a 1 in the
approved column.
You know, that really isn't a bad idea. I think I might try that
instead. Thanks!
Sep 20 '08 #3
Igoogler wrote:
On Sep 20, 1:24 pm, Captain Paralytic <paul_laut...@yahoo.comwrote:
>On 20 Sep, 21:20, Igoogler <Galat...@gmail.comwrote:
>>Here's what I want to do
I have a form on my site that lets people add a word and then submit
it. It gets submitted to a secondary database. I would then go to the
script and it would show all the words that were added and I could
approve or deny. By approving it would copy that specific row in the
secondary db to the primary which shows on the site live and by
denying it would keep it in the secondary (to prevent duplicates) and
remove it from the script approve/deny page.
I hope this all makes sense.
Thanks in advance,
Bryan
Why not just have one table with an "approved" column. When the word
gets written to the table, the approved column is blank, when you
approve it, put a 1 in.

The query to display words will only display those with a 1 in the
approved column.

You know, that really isn't a bad idea. I think I might try that
instead. Thanks!
Also, make the words column unique. That way no duplicate can be added.
Sep 20 '08 #4
On 20 Sep, 21:26, Igoogler <Galat...@gmail.comwrote:
On Sep 20, 1:24*pm, Captain Paralytic <paul_laut...@yahoo.comwrote:


On 20 Sep, 21:20, Igoogler <Galat...@gmail.comwrote:
Here's what I want to do
I have a form on my site that lets people add a word and then submit
it. It gets submitted to a secondary database. I would then go to the
script and it would show all the words that were added and I could
approve or deny. By approving it would copy that specific row in the
secondary db to the primary which shows on the site live and by
denying it would keep it in the secondary (to prevent duplicates) and
remove it from the script approve/deny page.
I hope this all makes sense.
Thanks in advance,
Bryan
Why not just have one table with an "approved" column. When the word
gets written to the table, the approved column is blank, when you
approve it, put a 1 in.
The query to display words will only display those with a 1 in the
approved column.

You know, that really isn't a bad idea.
I'm glad I've learnt something useful in all my years as an analyst/
programmer!
Sep 22 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Carlos Marangon | last post: by
2 posts views Thread by spike | last post: by
2 posts views Thread by Galahad | last post: by
4 posts views Thread by Dan | last post: by
2 posts views Thread by Markus Palme | last post: by
2 posts views Thread by shapper | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.