By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,949 Members | 1,824 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,949 IT Pros & Developers. It's quick & easy.

Simple PHP approve/deny

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.