[PHP] How do I do this select?

[Chris W]

I sent this to the mysql list but it doesn't seem to be working so I was 
hoping someone here could help.

I have the following 2 tables.

CREATE TABLE User (
  UserKey   INT NOT NULL AUTO_INCREMENT,
  UserID    CHAR(16) NOT NULL UNIQUE ,
  Name      VARCHAR(20),
  PRIMARY KEY (UserKey)
);
CREATE TABLE FriendList(
  UserKey     INT NOT NULL,
  FriendKey   INT NOT NULL,
  PRIMARY KEY (UserKey, FriendKey)
);
The second table is a many to many relationship table.  I want to select
 every row from FriendList and link it to userID so the out put looks
something like this.
UserID   FriendID  FriendName
a        x         x-name
a        y         y-name
a        z         z-name
b        a         a-name
b        c         c-name
b        z         z-name
c        b         b-name
c        x         x-name
This will give me sort of what I am looking for, but it shows the
UserKey in the first column and I want the UserID.  I have tried a few
others but just got errors.
SELECT f.UserKey, UserID FriendID, Name FriendName
FROM User u, FriendList f
WHERE f.FriendKey = u.UserKey
ORDER BY f.UserKey, FriendID;
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php