php - 在 mysql 中使用内部连接和 concat() 操作查询问题

Question

我有两个表:

sk_accounts      //details of user

• acnt_user_id
• acnt_fname//名字
• 账户名
• acnt_profile_picture
• acnt_member_class

• 等等.......

   sk_following   //table containing details of users who are following others
  

• 编号

• flwing_follower_id//被其他粉丝关注的用户id
• flwing_following_user_id

• 关注日期

  我想根据以下 Mysql 代码显示关注者的详细信息。不幸的是，它返回零行，尽管有 3 行。我的查询是这样的:

  $query_following = "SELECT sk_following.flwing_following_user_id, 
  sk_accounts.acnt_fname,
  sk_accounts.acnt_lname,
  sk_accounts.acnt_member_class,
  sk_accounts.acnt_profile_picture
  FROM sk_following 
  INNER JOIN sk_accounts 
  WHERE sk_following.flwing_follower_id='$id' AND        sk_accounts.acnt_user_id=sk_following.flwing_following_user_id AND CONCAT(sk_accounts.acnt_fname,' ',sk_accounts.acnt_lname)='$name'";
  $result_following = mysql_query($query_following);
  $count_following = mysql_num_rows($result_following);
  echo $count_following;
  

注意:$id和$name包含值请帮助我。提前致谢。

Answer 1

试试这个，

"SELECT sk_following.flwing_following_user_id,
sk_accounts.acnt_fname,
sk_accounts.acnt_lname,
sk_accounts.acnt_member_class,
sk_accounts.acnt_profile_picture 
FROM sk_following
LEFT JOIN sk_accounts ON sk_accounts.acnt_user_id=sk_following.flwing_following_user_id
WHERE sk_following.flwing_follower_id='$id'
AND CONCAT(sk_accounts.acnt_fname,' ',sk_accounts.acnt_lname)='$name'";

希望这对你有帮助。