[SOLVED] Check if record exists

[scottjcampbell]

Hi, i have been trying this for some time now, i will try my best to explain, but i am not very good at it.

 

I have a friends system on my website, that works fine, once a user accepts a friend request, their name, and the person who wants to be friends with the are put into a table like this:

 

I am now trying (And Failing) to make a script which will display a certain message if the user is friends with the person who's profile they are viewing, here is my code so far:

$username = $_SESSION['username'];
$q = "SELECT username,friendname FROM friends WHERE `username` = $requser";
$result = $database->query($q);

/* Display table contents */
for($i=0; $i<$num_rows; $i++){
$fname  = mysql_result($result,$i,"friendname");
}
if ($fname==$requser){
echo "YES!";
}else{
echo "NO!";
}

But i am always getting "YES!" even if they are not friends.

 

Variables:

• $requser is defined in the title of the profile (e.g domain.com/profile.php?user=test)
  
• $username is the person who is viewing the profile
  

So i wanted to make it that if $username (Viewer) is friends with $requser (Person who's profile they are viewing) then thry will see"Yes!", otherwise, they will see "No!"

 

P.S DATABASE CREDENTIALS ARE DEFINED ABOVE IN THE CODE

[budfroggy]

Use mysql_num_rows (http://us3.php.net/mysql_num_rows) to find out how many rows were selected. If it was 0, they arent friends, otherwise, they are friends.

 

[scottjcampbell]

Thanks, with your help, i have now completed this script.