|
| |
|
|
A1234
Posts: 101
Joined: 10/7/2004
Status: offline
 |
Turn search results on/off - 12/8/2004 12:04:08
I have a db allowing employers to search for employees. I'm trying to figure out how to allow an employee to log in and turn their profile "off" (if they do not with to have employers view their info), and also to turn the profile back on again if they wish. Anyone have any ideas? 
Thx
|
|
|
|
BeTheBall
Posts: 6385
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Turn search results on/off - 12/8/2004 12:21:46
Simply add a field to the database titled, Permission or something like that. I would make it a text field and then allow users to set it to Yes or No. Then in the SQL that searches the field, include in your WHERE clause, WHERE Permission = 'Yes'. That way, only records where the user has granted permission are returned.
Make sense?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
 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 
