can get my "add friends" script to work
Posted: Sun May 11, 2008 5:53 am
ok so in my table i currenty have
________________________
| username | by_user |
|------------------------- |
| Emma | Bob |
but im getting the error
QUERY ERROR:
SELECT * FROM `friend_requests` WHERE `by_user` = Bob
Unknown column 'Bob' in 'where clause'
but bob is right there lol... and surly if it cant find bob it should display the oage still
PHP Code:
________________________
| username | by_user |
|------------------------- |
| Emma | Bob |
but im getting the error
QUERY ERROR:
SELECT * FROM `friend_requests` WHERE `by_user` = Bob
Unknown column 'Bob' in 'where clause'
but bob is right there lol... and surly if it cant find bob it should display the oage still
PHP Code:
Code: Select all
<?php
session_start(); // starts sessions
include "../settings.php"; // inlcudes config
switch ($_GET[friends]) { //allows multiple pages
default:
$id = $_SESSION['user_id'];
$get_username_value = get_username($id);
$get = "SELECT * FROM `friend_requests` WHERE `by_user` = $get_username_value ";
$result= mysql_query($get) or die("QUERY ERROR:<br />{$get}<br />" . mysql_error() ); //gets requests
while ($reqs = mysql_fetch_array($get))
{
echo ( "Friend Requests
$reqs[by_user] wants to be friends with you.
<a href='newfriends.php?friends=accept&user=$reqs[by_user]'>Accept</a><br/>
<a href='newfriends.php?friends=delete&user=$reqs[by_user]'>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[user]' "); // 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[user]' "); // deletes friend request
echo ( "$_GET[user]'s request has been deleted" ); // echos completion
}
break; //ends delete page
} // ends switch
?>