How to link a column to another column of another table?

[kito2]

For example, like topic name says, link players.account_id to the id of the account, and when you click this value, it brings you to the account of the player followed by his id.

Anyone knows?

Rep++



Uploaded with ImageShack.us

 

[Cykotitan]

It brings you to the account? Not sure what are you trying to make ...

 

[kito2]

This is the idea, if I press the red square (1) it should bring me to account of the player sorted by the id (2):

 

[kito2]

BUMP and now with a image.



Uploaded with ImageShack.us

 

[richux]

What db manager are you using? How did you get this view of database?

 

[kito2]

Using phpmyadmin theforgotten server and the one of my server (tfs but with more tables and columns).

Select the database and press design.