Announcement

Collapse
No announcement yet.

Who referred me?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Who referred me?

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

  • #2
    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.

    Comment


    • #3
      And, if you want to see who referred who...
      Code:
      SELECT 
          user.username AS referred, 
          referrer.username AS referrer
      FROM 
          user
      JOIN 
          user 
      AS 
          referrer 
      ON 
          referrer.userid = user.referrerid
      ORDER BY 
          referrer
      Lats...

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X