|
| |
|
|
jonance
Posts: 298
From: Louisville KY USA
Status: offline
 |
Waiting area for database entries - 5/14/2002 18:23:53
Hello,
I am attempting to create a queue (or waiting area of sorts) for database entries to go until they are approved. What i have now (not sure if this is the best way) is one database with two tables, one is the queue and one is the actual database that is seen on the web. The trouble is how to handle the entries. I have it so when someone signs up on the site and fills out the form, it is uploaded to the queue. Then the owner of the site goes in and reviews it (via form fields pulling from the queue table) and submit it if accepted, which uploads it to the actual db. Then they have to delete it from the queue db. I feel like there are too many steps and this could be easier. Does anyone have suggestions. Is there an easy way to move a record from one table to another? Or would it make more sense to have them all in one db with a field like "approved" and if "yes" it is displayed on my pages, if not it isn't? This is one aspect of db programming i haven't gotten to yet...hope y'all can help.
Thanks,
John
|
|
|
|
Spooky
Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Waiting area for database entries - 5/14/2002 23:13:00
You really want to use one database.
Add a column as a bit or text value to designate whether the record is approved or not.
All of your SQL strings currently in use, will need to be modified so that the where clause only shows records that meet the selected criteria
"...where Approved = 'True'...."
Then, you only need to mark those records not yet approved as 'true' to enable them to be seen.
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
|
|
jonance
Posts: 298
From: Louisville KY USA
Status: offline
|
RE: Waiting area for database entries - 5/16/2002 13:56:32
Thanks spooky...i have done this but now have 1 problem on a
search page. I have the following sql:
SELECT * FROM listings WHERE (activated <> 'no' AND keywords LIKE '%::keywords::%' OR realname LIKE '%::keywords::%' OR description LIKE '%::keywords::%')
By all accounts it seems this should REMOVE the unactivated listings, which it does on my other pages with simpler criteria. But it still keeps showing up. Any idea why?
Thanks in advance,
JOhn
| |
|
|
|
Spooky
Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Waiting area for database entries - 5/16/2002 21:34:57
You may want to keep that part seperated from the other logic :
SELECT * FROM listings WHERE (keywords LIKE '%::keywords::%' OR realname LIKE '%::keywords::%' OR description LIKE '%::keywords::%') AND activated <> 'no'
So the stuff in brackets is important, but only if it meets the last criteria
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
|
|
jonance
Posts: 298
From: Louisville KY USA
Status: offline
|
RE: Waiting area for database entries - 5/16/2002 23:08:56
Perfect! Thanks....
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
