Du har skrivit SELCET i SQL-frågan istället för SELECT
Hej
Jag sitter och gör ett vän-system till min hemsida men nu så skickar man bara en vänförfrågning. men det konstiga är när man trycker på ja jag vill ha personen som vän så kommer det sedan upp ett felmeddelande som lyder:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/web77725l/domains/blabster.nu/public_html/scripts_for_profile/request_as_friend.php on line 19
Friend request sent successfully. This member must approve the request.
och koden är
<?php
$mem1 = preg_replace('#[^0-9]#i','',$_POST['mem1']);
$mem2 = preg_replace('#[^0-9]#i','',$_POST['mem2']);
if(!$mem1||!$mem2){
echo "Error: missing data";
exit();
}
if($mem1 == $mem2){
echo "Error: you cannot add yourself as a friend";
exit();
}
require('../scritps/connect.php');
if($_POST['request']== "requestFriendship"){
$sql = mysql_query("SELCET id FROM friends_requests WHERE mem1='$mem1' AND mem2='$mem2' Limit 1");
$numRows = mysql_num_rows($sql);
if($numRows>0){
echo "You have a friend request pending already for this member. They must approve it when they view their request first";
exit();
}
$sql = mysql_query("SELECT id FROM friends_requests WHERE mem1='$mem2' AND mem2='$mem1' Limit 1");
$numRows = mysql_num_rows($sql);
if($numRows>0){
echo "This user has requestes you as friend allready! Check your friends requests on your profile.";
exit();
}
$sql = mysql_query("INSERT INTO friends_requests(mem1, mem2, timedate) VALUES('$mem1','$mem2',now())") or die(mysql_error("Friend Request Insertion Error"));
//$sql = mysql_query("INSERT INTO pms (to, from, time, sub, msg) VALUES('$mem2','XXXXX',now(),'New Friend Request','You have a new Friend Request waiting for approval.<br /><br />Navigate to your profile and check your friend requests. <br /><br />Thank you.')") or die (mysql_error("Friend Request PM Insertion Error"));
//$id = mysql_insert_id();
echo 'Friend request sent successfully. This member must approve the request.';
exit();
}
?>
ser inte felet
rad 19 är
$numRows = mysql_num_rows($sql);
alltså allt lagras i databasens tabell friends_requests men det lagras också två gånger fast jag har kodat att det inte ska det vad e felen :(
/Robin K