[SOLVED] friendslist - if friends allready in db not working

[runnerjp]

i keep getting

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/runningp/public_html/members/include/friendrequest.php on line 16

has been sent a request you must now wait for it to be accepted

<?php
session_start();
require_once '../settings.php';
checkLogin ('1 2');

if ( !empty($_GET['user']) ) {
if ( ctype_alnum($_GET['user']) && strlen($_GET['user']) <= 10 ) {
  // further test and escape data
}

$user = $_GET['user'];
$get_username_value = get_username($id);
$query = "SELECT * FROM friends WHERE username ='$user' AND friendsname='$get_username_value'";
$result = $db->query($query);
$exist = mysql_num_rows($result);  // Does the row exists?
if($exist=='0')
{
$query = "INSERT INTO friend_requests (username ,by_user) VALUES('$user', '$get_username_value')";
  $result= mysql_query($query)
    or die("QUERY ERROR:<br />{$query}<br />" . mysql_error() );

  echo "$username has been sent a request you must now wait for it to be accepted";
  // useful in troubleshooting the SQL statement
  

} else {
  echo "you are allready friends with this user";
} 
}
?> 

[discomatt]

Check your querys. Somewhere you expect result rows and are not getting it. Avoid getting these errors by verifying with mysql_num_rows before using fetch functions

[rhodesa]

What is $db->query() ??? In other parts of the script you use mysql_query()

[runnerjp]

sorry i posted un chnaged version it is

switch ($_GET[friends]) { //allows multiple pages
default:
$query = "SELECT * FROM friend_requests WHERE `by_user` = '$get_username_value' LIMIT 1"; 
if ($result = mysql_query($query)){
    if (mysql_num_rows($result)) {
        $array = mysql_fetch_assoc($result);       
        $puser = $array['username'];
        $puser2 = $array['by_user'];
                }}                             
           ?>
      <?php echo ( "Friend Requests
$puser wants to be friends with you.
<a href='newfriends.php?friends=accept&user=$puser'>Accept</a><br/>
<a href='newfriends.php?friends=delete&user=$puser'>Delete</a>" ); //displays requests and shows accept delete links

break;

case 'accept': //accept page
if ($_GET[user]) { //get username
$get_username_value = get_username($id);
$add = mysql_query( "INSERT INTO `friends` (`friendname` , `username`) VALUES ('$_GET[user]' , '$get_username_value') "); // add to your friends list
$delete = mysql_query( "DELETE FROM `friend_requests` WHERE `by_user` = '$get_username_value' "); // deletes friend request
echo ( "$_GET[user] has been added as a friend and the request has been deleted" ); // echos the completion
}
break; //ends accept page

case 'delete': // delete page
if ($_GET[user]) { //gets username
$delete = mysql_query( "DELETE FROM `friend_requests` WHERE `by_user` = '$get_username_value'"); // deletes friend request
echo ( "$get_username_value's request has been deleted" ); // echos completion
}
break; //ends delete page
} // ends switch
?>

 

im getting the correct rows as i havent been told that its in the worng field or table or anything?

 

it wierd just Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/runningp/public_html/members/include/friendrequest.php on line 16

has been sent a request you must now wait for it to be accepted

 

its intresting that $_GET[user] has been sent a request you must now wait for it to be accepted does not show but is this due to the error