Add friend script, best practice?

[Concat]

What is best practice creating a "add friend" script for users?
The "friend" also need to confirm friendship.

CREATE TABLE friends (
id int(10) NOT NULL auto_increment,
me varchar(255) NOT NULL default '',
friend varchar(255) NOT NULL default '',
confirm int(1) NOT NULL default '',
blocked varchar(255) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

I think to add me and friend with confirm using int, 1 for confirmed, 0 for deny and 2 for pending.

Will it be a bad idea?

[rulian]

that is fine I think, it's pretty much how i've done it and it's worked for me.
If you arent familiar with JOINS or UNIONS however I would get to konw then because my entire relationship lines come down to JOINS and their ORDERS

[Concat]

I think to use INNER JOIN on the users table. Maybe the field 'blocked' clould be skipped, and use 'confirm' to verify.

0: deny
1: confirmed
2: pending
3: blocked

$me = $GET['me']; // or $SESSION

SELECT * FROM friends AS a INNER JOIN users AS b on a.me=b.username WHERE a.me ='$me'

and with PHP
..while {
$conf = $row['confirm'];
if ($conf ==0) {
$friend_status = "Not friend";
} elseif($conf ==1) {
$friend_status = "Is friend";
}
}

Will it do, or should i do it some other way? 😛

Edited:

I fount a tutorial at http://rmb-scripting.com/tutorials.php?tutorial&tid=282

They made a table 'friend_requests' that seem to better.

good 🙂