I try to make mini social media so, I have 3 table :
Followdata | Status 1 = Following, 0 Not Following :
Emaildari -> EmailKe mean A Follow B
emaildari emailke status
a@a.com b@b.com 1
a@a.com c@c.com 0
b@b.com c@c.com 1
b@b.com a@a.com 1
c@c.com a@a.com 1
c@c.com b@b.com 0
Status :
idstatus email des_status
1 a@a.com tes1
2 b@b.com tes2
3 b@b.com tes3
4 c@c.com tes4
Users :
email username
a@a.com ima
b@b.com imb
c@c.com imc
Myquestion is : how can i show the Status (post) by user email a@a.com and user that following by a@a.com so i get the result like :
Result :
idstatus username des_status
1 ima tes1
2 imb tes2
3 imb tes3
Please Help, Thaks in advance.
Aucun commentaire:
Enregistrer un commentaire