php - loop problem within a statement -

i hope can scream!

basically trying few things statement below;

first want check if user id exists in member_categories_position. if want exclude entries second statement member_id equals results first statement third statement else statement displays if member_id not present in member_categories position.

problem - result first system loops fine, when try , insert second statement (!='$memid') produces no results , has no effect. think problem $memid looped result.

how second statement member_id in member_categories_position not show in statement?

$sql2 = "     select *      member_categories_position      join member_users b          on b.id = a.member_id";  $rs2 = mysql_query($sql2); while ($row = mysql_fetch_array($rs2)) {     $memid = "".$row['member_id']."";    }  if(mysql_num_rows($rs2) != 0) {     $new= "         select *          member_categories          join member_users              on member_categories.member_id=member_users.id          join member_config              on member_categories.member_id=member_config.member_id                       member_categories.categories='$category'              , member_categories.member_id !='$field'           group member_config.member_id           order rand() limit 0,42";      $rs = mysql_query($new);      while ($row = mysql_fetch_assoc($rs))      {         echo "result excluding member ids first statement";     }     echo "<div class=\"clear\"></div>"; } else {      $new= "         select *          member_categories          join member_users              on member_categories.member_id=member_users.id          join member_config              on member_categories.member_id=member_config.member_id                      member_categories.categories='$category'          group member_config.member_id           order rand() limit 0,42";      $rs = mysql_query($new);      while ($row = mysql_fetch_assoc($rs))      {         echo "result member ids";     }     echo "<div class=\"clear\"></div>";  }  } <-- (second stray original post) 

$memid not in scope since appears defined inside loop. try defining $memid = ''; @ top of script.. this.

$memid =  ''; $sql2 = "          select *  

that way defined when use below..