[plantino]

You could write a simple SQL statement to do that.

[optomeb]

Well i figured out how to do a sql query that searches the user database and displays the refferal #, i just have to figure out how to translate that to the right username

[plantino]

Can't say I know off the top of my head what hte SQL is.

[optomeb]

At least i know it can be done:)

[plantino]

Do you have a relationship between the referral number and the username?

[optomeb]

Yes the refferal number is the userid of that username

[plantino]

Then you just need to use a JOIN statement to join the referral number in one table to the username in another.

[optomeb]

For example, I (user 1) reffer john (who is user 4). john will have a value in his database called $ref where the value is 1

[plantino]

All doable.

[optomeb]

But i dont have a value that says i reffered john
plantino, the problem is how can i join it if its all in the same database ?
Same table i mean
:)