How to user insert... select... with my two tables based on id?

[Max45]

How to user insert... select... with my two tables based on id?
Hi all,
I have two tables
Table1_Name= users ->Which has all users
Tabel2_Name=addfriend -> which I to want add users to it from table1(users) based on their id
Here my code that didn't work

$id = $_GET['id'];
  $sql = "INSERT INTO addfriend(fname)
SELECT fname,  
FROM users WHERE id = $id"; 

   

Edited April 11, 2020 by Max45

[Barand]

Table "addfriend" should contain (userid, friendid) only - no name. Don't bother. Problem solved.

Also, having a row with just a name will not tell you whose friend it is.

For future reference, "didn't work" tells us absolutely nothing about your problem.

And just posting a query that "doesn't work" only tells us what you don't want to do, not what you are trying to do.

[Max45]

19 hours ago, Barand said:

Table "addfriend" should contain (userid, friendid) only - no name. Don't bother. Problem solved.

Also, having a row with just a name will not tell you whose friend it is.

For future reference, "didn't work" tells us absolutely nothing about your problem.

And just posting a query that "doesn't work" only tells us what you don't want to do, not what you are trying to do.

Thanks a lot buddy.

And sorry if my post is not understandable.

See ya