Check mysql database for user

[monkeybidz]

Im trying to check if a user exist in database table only if another check =YES:

 

$sql="SELECT * FROM my_members WHERE my_private=$my_private AND my_id=$my_id";

 

$my_private should = 'Yes' or 'No'.

 

If 'Yes', i need to run another check....

 

$sql="SELECT * FROM my_favorites WHERE my_id=$my_id AND my_uid=$sessionuser";

 

This check should check to see if $sessionuser exists in my_favorites..

 

How can i make the first one call the second only if $my_private=Yes? Or is this code even correct?

[Psycho]

How about 1 query instead?

 

$sql="
  SELECT mf.*
  FROM my_favorites mf
  RIGHT JOIN my_members mm
      ON mf.my_id = mm.my_id
  WHERE mf.my_id=$my_id
      AND mf.my_uid=$sessionuser
      mm.my_private=$my_private";

[ShoeLace1291]

$sql="SELECT * FROM my_favorites WHERE my_id=$my_id AND my_uid=$sessionuser";

 

$num = mysql_num_rows($sql);

 

if($num > 0){

 

do some action

 

}

[monkeybidz]

Both did not work for me in that page, but did work in others. What i cant get it to recognize both variables at the same time.

 

If($my_private=='Yes' && !$sessionuser) {

      header("Location: gen_confirm.php?errmsg=".urlencode("This user has profile set to private. Only friends can view this page.<BR><a href=".addme_request.php.">Click here to request to be added.</a>"));

die();

}

 

I can get it to check the my_private, but not the my_ud from database.  ???