create table friends
id int not null auto_increment,
constraint fk_friends_accounts foreign key (user_id) references
foreign key (friend_id) references accounts(id),
this is my friends tables..friend_id is the field where ids of the
user are filled but before filling that friend_id field,a request is
to be sent to the user who is supposed to be added.
here i request suggestions for how to send that friendrequest...
thanks in advance.