I have two databases, where I store who is following who and another which stores the posts the user makes.
I want to select all of the people a user is following from the following database and echo out the usernames of those who that user is following and query the posts database for posts of that user.
My problem is what if a user is following multiple users,
I echoed out of the user id's of the people this user is following and I get
44443344330
When I separate each id with commans, I get:
44,44,33,44,33,0,
so let's give that a variable of $user_ids;
$user_ids = "44,44,33,44,33,0, ";
the query:
$get_posts = mysql_query("SELECT * FROM posts WHERE userid = '$user_ids'");
but all it does is show the records of the first user id, 44.
How can I retrieve all of the records for all the users?
解决方案
The query should be:
SELECT * FROM posts WHERE userid IN (44,44,33,44,33,0)
However, you may have to rethink your data model and make sure it is normalized, so that you can express this construction directly in the databse without echoing into a comma-separated string.
Why do you have two databases? Do you mean two tables?