[SOLVED] query problem

[timmah1]

I'm not sure the correct way to do this or to word this.

I need to be able to select everything posted from myself and from people that I'm subscribed to.

 

I tried JOINS, but I do not get the results I need, so I remember someone before showing me a different way, but all I keep getting are results for me, not from who i subscribe to as well.

 

Here is my code

<?php
$query2 = "SELECT * FROM users1 WHERE userid = '$user'";
                    $result2 = mysql_query($query2);
                    $p2 = mysql_fetch_assoc($result2);
					$follower = $p2['followers'];
					$me = $p2['userid'];

		//Grab all posts from user, and from their subscribers
		$query = "SELECT * FROM posts WHERE userid = '$follower'";
		$query = "SELECT * FROM posts WHERE userid = '$me' ORDER BY posted DESC";
                    $result = mysql_query($query);
                    while($p = mysql_fetch_assoc($result)){

					$posted = date("F j, Y g:i a", strtotime($p['posted']));
					$going = $p['going'];
					$city = $p['city'];
					$state = $p['state'];
					$p_user = $p['userid'];
					$p_folow = $p['followers'];
?>

 

Basically, I need to grab all posts from $me and from $follower.

 

Can anybody show me the correct way?

 

Thanks in advance

[Maq]

Why can't you just do this?

 

$query = "SELECT * FROM posts WHERE userid = '$follower' OR userid = '$me' ORDER BY posted DESC";

[timmah1]

Because it has to grab both

 

I tried this

$query = "SELECT * FROM posts WHERE userid = '$follower' AND userid = '$me' ORDER BY posted DESC";

 

But I get no results then

[Maq]

Yeah, you need to use OR.

 

userid can't be 2 different numbers at the same time, you know what I mean?

[timmah1]

I understand that.

 

I can't use OR, because then it's only going to grab everything from either or, I need it to be both.

But I need to try and be able to pull all of the posts from the users is, as well as the follower id.

 

 

[timmah1]

I got it to work with the OR, I didn't realize that would work

 

Thanks for your help Maq.

[Maq]

I got it to work with the OR, I didn't realize that would work

 

Thanks for your help Maq.

 

Hehe, sure buddy.  Don't worry, I always get confused with logical operators