- /************************************/
- //最新好友更新 Model
- /************************************/
- $update_query=mysql_query("select * from
- b_friend LEFT JOIN b_blog ON b_friend.g_user= b_blog.blog_user
- INNER JOIN accounts on b_blog.blog_user= accounts.user_name
- INNER JOIN accounts_info ON accounts.user_id=accounts_info.accounts_u_id
- where b_friend.b_user='".$get_username."' and b_friend.friend_type=2 order by b_blog.blog_addtime desc");
- while ($update_row=mysql_fetch_array($update_query)){
- $cmment_accounts_name[]=$update_row["accounts_name"];
- $cmment_image_title[]=$update_row["blog_title"];
- $comment_image_id[]=$update_row["blog_id"];
- $comment_image_user[]=$update_row["user_name"];
- }
- /************************************/
- //最新好友更新 Model
- /************************************/
最近在写BLOG(最新好友更新)用的MYSQL四表查询
最新推荐文章于 2022-12-18 19:42:30 发布