Who referred me?

[triphp]

Is there a way, either template conditional or in code, to know who referred me?

[triphp]

Oops sorry, I got it. It's a dumb question of mine.

Could be something like: "SELECT * FROM user WHERE userid=my_referrer_id"

Please closed the thread.

[Lats]

And, if you want to see who referred who...

SELECT 
    user.username AS referred, 
    referrer.username AS referrer
FROM 
    user
JOIN 
    user 
AS 
    referrer 
ON 
    referrer.userid = user.referrerid
ORDER BY 
    referrer