https://www.icyphoenix.com/viewtopic.php?f=35&t=7807&p=52542#p52542 ----------------------------------- mort Wed 20 Apr, 2011 15:43 Re: Delete Pots From User Deleted ----------------------------------- [quote user="Informpro" post="52531"]Imagine you delete the first post of a thread (because the author of the thread has been deleted). Could you guess what will happen ?[/quote] You're right - It does remove the thread. :( But! if anakin isn't worried about that, here's the string he will need to do it with. [code linenumbers=false]DELETE FROM ip_posts WHERE post_username= "informpro" AND poster_id= -1;[/code] Just change [b]informpro[/b] to whatever the user handle is. :mryellow: It's also important that the name be inside quotes. [b]"[/b]user name[b]"[/b] and NOT [b]`[/b]user name[b]`[/b]