Re: Re: delete user but keep the article

> > 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...