SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Query Help

Hybrid View

  1. #1
    SitePoint Zealot webhost's Avatar
    Join Date
    May 2001
    Location
    Il
    Posts
    194
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Query Help

    I have forum like this one need some help with a query.

    I have been using username1 for my admin name on my forum. Now I want to change my username to say username2. By doing this I need to run a query in phpmyadmin to update a table called post and a table called thread. I need to run a query on both tables that will change username1 to username2. Any ideas on this query.

    Tables called
    post fields in post table is called username and thread posterusername and lastposter

    both have a userid in the table and for this user name it is userid7

    Hope this makes sense.

  2. #2
    Are you ready for BSD? Marshall's Avatar
    Join Date
    Dec 2001
    Posts
    373
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You need something similar to:
    Code:
    UPDATE MyTable SET AdminName = 'username2' WHERE AdminName = 'username1'
    - Marshall


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
  •