01.<?
02.
03.
04.
05. $sqlall = "SELECT * From tb_friend where f_mid_at1 = '5' or f_mid_at2 ='5' HAVING f_accept='1'";
06.
07. $queryall = mysql_query($sqlall);
08. $sql_check_member="select * from tb_member where m_status='1'";
09. while($dbdd= mysql_fetch_array($queryall))
10. {
11.
12. if($dbdd[f_mid_at1]==$user)
13. {
14. $sql_member="select * from tb_member where m_id=$dbdd[f_mid_at2] ";
15. $query_member=mysql_db_query($dbname,$sql_member);
16. $db_member=mysql_fetch_array($query_member);
17. if($db_member[m_status]=='1')
18. {
19. $status="online";
20. }
21. else
22. {
23. $status="offline";
24. }
25. $m_image=$db_member[m_image];
26. $m_name=$db_member[m_name];
27. }
28. else
29. {
30. $sql_member="select * from tb_member where m_id=$dbdd[f_mid_at1] ";
31. $query_member=mysql_db_query($dbname,$sql_member);
32. $db_member=mysql_fetch_array($query_member);
33. if($db_member[m_status]=='1')
34. {
35. $status="online";
36. }
37. else
38. {
39. $status="offline";
40. }
41. $m_image=$db_member[m_image];
42. $m_name=$db_member[m_name];
43. }
44. ?>
45.
46. <img src="<?php echo $m_image;?>" title="<? echo $m_name;?>" alt="" width="70" height="70" />
47. <? echo $status; } ?>
เยี่ยมครับ
