MySQL Query JOINS are not retrieving fully
On my website I am trying to program a feature, similar to facebook and twitters timeline, where a user can 'follow' another user, and receive their 'broadcast'. The database tables are:

    members | broadcasts
               id | id
     fullname | mem_id
    following  | broadcast (the content)
                  | broadcast_date

"following" in the members table is a varchar text that stores user ID's. So if I'm following users 4 5 and 6 (4,5,6,) would appear in the following column. My problem is, what I'm querying from the database, it's only retrieving the 'broadcasts' from the first user that I am following and no other user else.

    $sql_broadcasts = mysql_query("SELECT *
    FROM members JOIN broadcast ON(broadcast.mem_id = members.follower_array)
    WHERE members.id=$id
    ORDER BY broadcast_date DESC
    LIMIT 10;
    ");

where $id is $_SESSION['id']. I've been staring at this code for a long time, can anyone spot what I'm doing wrong? thanks in advance

MySQL Query JOINS are not retrieving fully
===

On my website I am trying to program a feature, similar to facebook and twitters timeline, where a user can 'follow' another user, and receive their 'broadcast'. The database tables are:

    members | broadcasts
               id | id
     fullname | mem_id
    following  | broadcast (the content)
                  | broadcast_date

"following" in the members table is a varchar text that stores user ID's. So if I'm following users 4 5 and 6 (4,5,6,) would appear in the following column. My problem is, what I'm querying from the database, it's only retrieving the 'broadcasts' from the first user that I am following and no other user else.

    $sql_broadcasts = mysql_query("SELECT *
    FROM members JOIN broadcast ON(broadcast.mem_id = members.follower_array)
    WHERE members.id=$id
    ORDER BY broadcast_date DESC
    LIMIT 10;
    ");

where $id is $_SESSION['id']. I've been staring at this code for a long time, can anyone spot what I'm doing wrong? thanks in advance
