Hllo,
I am stuck with a sql query on my PHP page. i think is a simple problem, but i am confused. There is a table with membername and member unique id. The opther table has fields such as member_id1, member_id2. How do i form a query, which can show the SECOND table, with actual member names from table one?
i am using mysql
For example, i have:
---table 1
name,id
andy, 1
brown, 3
joseph, 2
---table 2
1,3
2,1
1,2
etc.
I want to get, by table 2
andy brown
joseph andy
andy joseph
etc.
Thanks.
I am stuck with a sql query on my PHP page. i think is a simple problem, but i am confused. There is a table with membername and member unique id. The opther table has fields such as member_id1, member_id2. How do i form a query, which can show the SECOND table, with actual member names from table one?
i am using mysql
For example, i have:
---table 1
name,id
andy, 1
brown, 3
joseph, 2
---table 2
1,3
2,1
1,2
etc.
I want to get, by table 2
andy brown
joseph andy
andy joseph
etc.
Thanks.