SitePoint Sponsor

User Tag List

Results 1 to 6 of 6

Hybrid View

  1. #1
    SitePoint Enthusiast 'K''s Avatar
    Join Date
    Mar 2003
    Location
    UK.West Sussex
    Posts
    40
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Search and Remove - phpMyAdmin

    Hi,

    On my hosting I have setup a forum and basically for a certain member who has been banned I would like to remove all trace of him so basically in phpMyAdmin is there a querie I can run in a table to remove a/all rows containing

    "whatever" under the "author_name" column so that the entire row/rows which contain "whatever" under the "author_name" column will be removed.

    Thanks

    btw the Forum is InvisionBoard if anyone needs to know.

    Cheers

  2. #2
    SitePoint Wizard
    Join Date
    Mar 2002
    Location
    Bristol, UK
    Posts
    2,240
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    DELETE FROM table_name WHERE author_name = 'whatever';

    is the syntax. Sorry I'm not familiar with the workings of Invision Board so I can't give you the exact specifications

    -Sam
    Sam Hastings

  3. #3
    SitePoint Enthusiast 'K''s Avatar
    Join Date
    Mar 2003
    Location
    UK.West Sussex
    Posts
    40
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    Thanks for that

    I'll go try it.

  4. #4
    SitePoint Wizard
    Join Date
    Mar 2002
    Location
    Bristol, UK
    Posts
    2,240
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hold on a sec... in the admin panel of IB, if you delete a user, if I remember correctly, all of that user's posts will be purged as well. No need to use phpMyAdmin here.

    -Sam
    Sam Hastings

  5. #5
    SitePoint Enthusiast 'K''s Avatar
    Join Date
    Mar 2003
    Location
    UK.West Sussex
    Posts
    40
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Unfortunatly with iB it doesnt purge the posts.

    The phpMyAdmin route worked though Thanks!

    Would there be any way to make a page where you enter into a textbox the table name, and into another the author_name so I could use this in the future, and I guess the SQL Connection info would have to go in the page someplace but I have no clue when it comes to this

    If you could help that would be great

  6. #6
    SitePoint Enthusiast 'K''s Avatar
    Join Date
    Mar 2003
    Location
    UK.West Sussex
    Posts
    40
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    or if anyone else can help with the above, page creation, then i'd appreciate it

    Thanks a lot guys.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •