[SOLVED] query...

[phorcon3]

ID                         ArticleID                    User

1                          1                              test

2                          5                              test1

3                          28                             test

4                          28                             test1

 

whats the query to find the articleID where both, test and test1, are included? = 28

 

<?php


$a=mysql_query("SELECT `ArticleID` FROM `table` WHERE `User` = 'test' ORDER BY `ID` DESC");
while($b=mysql_fetch_assoc($a))
{
$article_a=mysql_query("SELECT `ID` FROM `table` WHERE `User` = 'test1' AND `ArticleID` = '$b[ArticleID]'");
$article_b=mysql_fetch_assoc($article_a);

if($article_b['ID'])
{
echo $b['ArticleID'];
}
}

 

but that wouldnt be very efficient since im usin two queries

 

...can anyone help me with this please?

[PFMaBiSmAd]

This thread might help - http://www.phpfreaks.com/forums/index.php/topic,200503.0.html

 

You need to do a count and group by the ArticleID and then use a HAVING clause.

[phorcon3]

thanks, man!

 

but for some reason IN(test,test1) didnt work ...but WHERE (`user` = 'test' OR `user` = 'test1') worked..?! dunno...