if statement echoing both 'if' and 'else'?

[liamallan]

this is proving tougher than i thought! i have tried allsorts but nothing is working.

this is what i have now:

if ($fris['friendname'] != $req_user_info['username']){ //checks if user isnt a friend
    echo "<a href=\"friendrequest.php?user=".$req_user_info['username']."\" title=\"Become Friends With ".$req_user_info['username']."\"><img src=\"friends_icon.png\" width=\"25\" height=\"25\" border=\"0\" /></a><br>";
    }
    else{
        echo "[<font color='#666666'>You are friends</font>]";
    } 

problem with this is, it echoes 'you are friends' with one of my friends, and the option to add as friend with the rest of my friends. its like the query isnt selecting all from table but query looks ok, here it is:

$get = mysql_query( 'SELECT * FROM `friends` WHERE `username` =  \''.$username.'\''); //gets friends
$fris = mysql_fetch_array($get); 

anybody got any ideas?

[bluewalrus]

echo the results

[liamallan]

i tried echoing $fris and $fris['friendname'] and both no results. all i want to do is select all the friend name column from table friends where the session username is in column 'username'

[liamallan]

i dunno if this is anything to do with it, but i am trying to achieve this within an existing else thingy

[liamallan]

no worries guys, i finally sussed it

now i have this:

$getFriends = mysql_query("SELECT * FROM `friends` WHERE `friendname` = \"".$req_user_info['username']."\" AND `username` = \"".$session->username."\"");
if (mysql_num_rows($getFriends) == 0){ 
   echo "<a href=\"friendrequest.php?user=".$req_user_info['username']."\" title=\"Become Friends With ".$req_user_info['username']."\"><img src=\"friends_icon.png\" width=\"25\" height=\"25\" border=\"0\" /></a><br>";
  } 
 else {
    echo ( "<br>[<font color='#666666'>You are friends</font>]<br>");
} 

thanx for all your help anyway