|
|
Posted by Jasen Betts on 10/13/75 11:39
On 2006-02-07, frizzle <phpfrizzle@gmail.com> wrote:
> Hi there
>
> I've built this user management system, using PHP & mySQL, to manage
> users that can comment on a certain site. Users have to be logged in to
> comment. Below each comment is (how original) the date of
> commenting, and the author.
>
> If the user changes his name in his profile, it changes everywhere. So
> what i mean is that the user_id is saved together with the comment.
> When the comment is pulled out, the query also gets the user's name.
>
> My question:
> What is usually done with users deleted from the member system: this
> would lead to a blank name on every appearance of a deleted user's
> comment.
> Or how do i prevent the blank space, and still show the user's name?
Don't delete the user, mark them as inactive (or historical) instead.
you could do this by addin a boolean field for this info, to the users
table or by putting a certain value in the password field (etc...)
Bye.
Jasen
Navigation:
[Reply to this message]
|