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]