Re: delete user but keep the article

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" <rsalomo@telkom.net> schrieb im Newsbeitrag 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. >