|
|
Posted by Stanch on 02/07/06 11:58
Do you still want to show the deleted user's comment?
Instead of removing the user from the database, you can use a flag
value. You can have a 'status' column that says active or inactive
(1/0), with a default value of active. When the user is deleted from
member system, set the status to inactive.
This way the comment will still show the username. Or you can choose to
just select/display comments from active users.
However, in other places where you need to know whether a certain user
is active (such as user list), you have to do a "select * from
usertable where status=1" so that you're selecting active users only.
I'm not expert. Hope this helps!
Navigation:
[Reply to this message]
|