Excluding values in an array from the query

lajkonik86

I'm trying to exclude variables in an array from my query
(need it to display latest threads a user posted in, excluding threads he started, cause i'm showing those seperately)

This is my current code:

//Mythreads Latest you posted in
$Recordset2 = mysql_query("SELECT DISTINCT `topic_id` FROM `phpbb_posts` WHERE `poster_id` =2
AND `topic_id` != '$id' ORDER BY `post_time` DESC LIMIT 0 , 4") or die(mysql_error());
$blue = 0;
while ($results = mysql_fetch_array($Recordset2)) 
					{

				 	  	 $id[$blue] = $results[topic_id];
						 $title[$blue] = $results[topic_title];
					     $blue++;		
					     if ($blue == 5) break;
				}
$Recordset2 = mysql_query("SELECT * FROM `phpbb_topics`") or die(mysql_error());
while ($results = mysql_fetch_array($Recordset2)) 
					{

						 $names["$results[topic_id]"] = $results[topic_title];
				}

topic_id != '$id' is what i want to do but this doesnt work for arrays.

Could someone please point me in the right direction

paulnaj

If $id is an array, then you can use the IN operator instead ...

topic_id NOT IN ('".join("','", $id)."')

Paul 🙂

lajkonik86

('".join("','", $id)."')

Could you explain that 🙂

leatherback

THere is this nice thing called manual where they explain that join is an alias of implode
and is used to

Returns a string containing a string representation of all the array elements in the same order, with the glue string between each element.

paulnaj

join() takes two arguments ... a separator and an array to 'join' together. In this case, the separator is ',' (enclosed within double-quotes whan passed to join()).

The reason is that IN() expects a comma-separated list of values like ...

IN('value1','value2','value3', ... ,'valueN')

... and you can see that, as a string in PHP, the values are separated by ','

Hope that helps.

Paul 🙂

lajkonik86

That helps allot 😃
Thanks !!