I'm struggling with a MySQL query where I would like to pull back an array of all the peoples ID's that a person has favorited but I keep getting "Error Code: 1242. Subquery returns more than 1 row"
Here's the basic SQL, it grabs the [usr_id] and [usr_username] from the [users] table and then I would like a comma separated list of all that persons [uf_favourited_user_id] from the [user_favourites] table
SELECT usr_id, usr_username, (SELECT uf_favourited_user_id FROM user_favourites WHERE uf_user_id = 19) AS favourites
ORDER BY usr_date_registered