|
|
Posted by frizzle on 02/07/06 12:05
Stanch wrote:
> 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!
@Steve
I don't completely understand what you're saying, but i guess it's the
same as Stanches option ... (?)
What i don't get is "$0.02"
@Stanch, that's what i thought of too, but i wasn't too sure of this
method (i use 'deleted = 0/1') was ok, because a deleted user would
still burden the DB.
Thanks.
Frizzle.
Navigation:
[Reply to this message]
|