How to view other users profile

programming
1

I know to use sessions when I am retrieving data from my database,to see my own profile, but I want to make other members usernames a link so that when i click on their name, it shows me there profile. How is this done with php and sql