SELECT...FROM...WHERE xxx='a whole list' ?????

[jonsof]

Is this practicable?

[DigitalExpl0it]

yes but you need to use a array for it 🙂

[DigitalExpl0it]

kinda like this

$split_search = explode(" ",$searchtxt);
for($i = 0; $i < count($split_search); $i++)
{

$gosql5 = "SELECT * FROM code WHERE Cpdec LIKE '%$split_search[$i]%' ORDER BY Cid ASC";
$result = mysql_query($gosql5, $goconnect5) or die("Could not execute query.<br>"); 

[jonsof]

I put

$result1=mysql_query("SELECT categoryid FROM user_category WHERE userid='$user_id'");

$cat=mysql_fetch_assoc($result1);

foreach($cat as $value) {
$result2=mysql_query("SELECT categoryid, category FROM categories WHERE categoryid='$value'");}

 while($row=mysql_fetch_assoc($result2)) {
 echo "<option value=".$row['categoryid'].">".$row['category']."</option>";}

But ti didn;t work 🙁🙁

user_category is a table that contains the userid and the categoryid, one user many categories.

So i expected that $cat returns an array with all the categoryid's but it didn't happen but only one categoryid appeared.

What have i done wrong?

[mikeatrpi]

SELECT c.categoryid, c.category FROM user_category u, categories c WHERE u.userid='$user_id' AND c.categoryid = u.categoryid

Will this give you the intended result?

[jonsof]

Than you mikeatrpi
It worked very very well!!!