php referal help

[ctcp]

mysql database

table  referals

ID | user | referal

1  | ctcp | alex |

2  | ctcp | alex2|

 

table liked

ID | user_id |

1  | 1

2  | 2

 

Im working my referal script and i whant give points to referal account

if

$ref = mysql_query("SELECT * FROM referals WHERE user = '$data->login'");

 

account exist in referals and if account id exist in liked

 

how can i do this?

 

 

[RussellReal]

I don't quite understand what you want.. if you mean you want to count the number of rows in table_B which match an ID from table_A, here is how you will do it:

 

$user_id = 1;
$qry = "SELECT count(id) FROM referals A JOIN liked B ON (A.id  = B.user_id) WHERE A.id = '$user_id'";

[ctcp]

thank you for your replay

i don't whant to count but comparison