I'll try to represent the table here
Code: Select all
table users
- userID
- parentID
- username
- sponsorCode: Select all
UPDATE users SET parentID = (SELECT userID FROM users WHERE username=sponsor)Moderator: General Moderators
Code: Select all
table users
- userID
- parentID
- username
- sponsorCode: Select all
UPDATE users SET parentID = (SELECT userID FROM users WHERE username=sponsor)Code: Select all
UPDATE users u1, users u2 SET u1.parentID = u2.userID where u1.sponsor = u2.username