[SOLVED] checking if user is allready a friend

[runnerjp]

ok so in my db i have this

 

friendname    username

  admin          emma

  emma          admin

 

 

easy set up really....

 

so on a users profile i have this

 

<?php
echo "<a href='index.php?page=friendrequest&user=$username'>Add as Friend</a>";
?> 

 

how can i only display this if a user is not friends with a user or its that users profile??

 

 

if

user == ?

 

else

 

show <?php

echo "<a href='index.php?page=friendrequest&user=$username'>Add as Friend</a>";

?>

[craygo]

I would assume username is the current person doing the browsing and $friendname will be used for the person. With that said try something like this

<?php
$sql = "SELECT `friendname` FROM `tablename` WHERE `username` = '$username' AND `friendname` = '$friendname'";
$res = mysql_query($sql) or die(mysql_error());
$found = mysql_num_rows($res);
if($found < 1 || $username != $friendname){
echo "<a href='index.php?page=friendrequest&user=$username'>Add as Friend</a>";
}
?>

 

Ray

 

 

[dannyb785]

I would assume username is the current person doing the browsing and $friendname will be used for the person. With that said try something like this

<?php
$sql = "SELECT `friendname` FROM `tablename` WHERE `username` = '$username' AND `friendname` = '$friendname'";
$res = mysql_query($sql) or die(mysql_error());
$found = mysql_num_rows($res);
if($found < 1 || $username != $friendname){
echo "<a href='index.php?page=friendrequest&user=$username'>Add as Friend</a>";
}
?>

 

Ray

 

 

 

This is correct, except I believe it should be $found < 1 || $username != $friendname

 

I'd also suggest making it $found == 1, not that it needs to be, it's just better for visualizing what's going on "If we aren't friends and this user isn't me, then display the link"

[runnerjp]

ok i did this

 

<?php
$sql = "SELECT `friendname` FROM `friends` WHERE `username` = '$useronline' AND `friendname` = '$username'";
$res = mysql_query($sql) or die(mysql_error());
$found = mysql_num_rows($res);
if($found == 1 || $username != $friendname){
echo "<a href='index.php?page=friendrequest&user=$username'>Add as Friend</a>";
}
?>

 

with

 

$username=$_GET['username']; --- getting the users profile name

$useronline= get_username($_SESSION['user_id'] -- getting th username of the user logged in

 

 

but it still displays the link no matter if the are friends or not

[sasa]

if($found < 1 and $username != $useronline){

[dannyb785]

lol wtf I have no idea what I was thinking when I posted my reply