php - 这个mysql查询有什么问题吗？

Question

请查看以下查询:

SELECT tc.registered, t.id, u.x_account_username
                        FROM x_trybe_comments tc
                        LEFT JOIN x_user u
                        ON tc.profile_id = u.id
                        LEFT JOIN x_trybes t
                        ON tc.trybe_id = t.id
                        WHERE u.id IN ('%s')
                        AND tc.trybe_id IN ('%s')

$query      =   sprintf($query, $contacts, $trybes);

我正在尝试选择 x_trybe_comments 中的所有评论，我的联系人是该评论

i.e. u.id IN ('%s')

在我的尝试中

i.e. tc.trybe_id IN ('%s')

“%s”被数组的 implode() 替换。

我从两个函数获取数组，如下所示:

    $contacts = getContactIds($db,$profile_id);
    $trybes = getTrybesJoinedOrOwned($db,$profile_id);
    $contacts = implode("', '", $contacts);
    $trybes = implode("', '", $trybes);

trybes 和联系人的输出:

Trybes: c341f36cc31c7e22c4ec00fd484c1fc03a7b2dfd', 'baa764365ac0a4ba044651ca46b08aa8de74e288', 'a9f4fba45750075eccda69f6645d6240c8889b10', '4ce48a7c7c21f82dc632bde72305d1330e1ac28 

Contacts: 1dd36ac747735a3ee8a1d47750e1515ab7ac0d53', 'dc19818afa52859032bdde290b900e3763ba54d0', '397cde4302885e167004494340971f4550346e04', 'c73fb8efa74354e721a5a945a5c367f486a3d80b', 'c484c72086ed2fdbd859954a2a753b07c4bd1f1d

以下是相关查询的回显:

SELECT tc.registered, t.id, u.x_account_username
                        FROM x_trybe_comments tc
                        LEFT JOIN x_user u
                        ON tc.profile_id = u.id
                        LEFT JOIN x_trybes t
                        ON tc.trybe_id = t.id
                        WHERE u.id IN ('1dd36ac747735a3ee8a1d47750e1515ab7ac0d53', 'dc19818afa52859032bdde290b900e3763ba54d0', '397cde4302885e167004494340971f4550346e04', 'c73fb8efa74354e721a5a945a5c367f486a3d80b', 'c484c72086ed2fdbd859954a2a753b07c4bd1f1d')
                        AND tc.trybe_id IN ('c341f36cc31c7e22c4ec00fd484c1fc03a7b2dfd', 'baa764365ac0a4ba044651ca46b08aa8de74e288', 'a9f4fba45750075eccda69f6645d6240c8889b10', '4ce48a7c7c21f82dc632bde72305d1330e1ac280', '408032a6043f6789083c4919474969f6d47abb1c', 'f8fbf59d242794cc6c00932a8ef643587338d189', '76fb8332f5808111f6e83e5a8f9068ff911850e5', 'd62243e0026e8d4c48143549b421e492ba1a840f', '580861afde002c536466db9ae953e43c47b3eeab', 'faebdc82b8bcf8fbb5db56c3c3b805f3e1fda5a2', '297cebfa7522e253d65d1fd6f5f904ca5b626905')

你能看出我做错了什么吗？

谢谢

Answer 1

我是个白痴，我返回的是 $result 对象而不是我的 $array 数据

感谢您的评论，问题已解决!