Simple PHP approve/deny

Igoogler

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

Captain Paralytic

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

Igoogler

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

sheldonlg

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

Captain Paralytic

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