|
|
Posted by Steve on 02/07/06 11:50
On Tue, 07 Feb 2006 01:38:34 -0800, frizzle 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?
>
> Greetigs Frizzle.
I never change user details, rather I create a new one with a new ID. That
way, you never have that problem, and the quotes stay attributed to the
person who made them at the time. All you need to do is to add a validity
flag to the user details.
$0.02,
Steve
Navigation:
[Reply to this message]
|