Re: [PHP-DB] Re: delete user but keep the article

[speedboy]

> > i want to delete user_x, but keep article abc.
> > how php/mysql display that there is article named 'abc', input by
> 'user_x',
> > but there are no further information about that user (except maybe only

Have a user status, 1 = active, 2 = deleted.

So when they are deleted their account is made inactive but their username
still exists so it will show that when you do the query on their
particular article(s). Then just modify the queries for other areas on
your webpage to not show them as an active user.

It does not require much space to keep the rest of their information...


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: delete user but keep the article

[Robert Hennig]

hi Rsalomo,

it seems you would have to do some more work. At the moment I see to
possible ways to fix this:

- Re-design your application so that the news articles don´t need a
corresponding entry in the users table. Find another way to link user and
entry.
- Do some code which is executed when deleting this user and which  edits
the tables so that the user entry is another one.

Robert
"Rsalomo" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
039c01c1256b$93d54300$0700a8c0@tiger">news:039c01c1256b$93d54300$0700a8c0@tiger...
> hi,
>
> i have a news article database that input by users, for example
articlename:
> 'abc', input by username: 'user_x'.
>
> i want to delete user_x, but keep article abc.
> how php/mysql display that there is article named 'abc', input by
'user_x',
> but there are no further information about that user (except maybe only
his
> firstname) because user_x no longer exists.
>
> how can i do this?
>
> thanks
>
> rudy.
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]