I am using the AMS module and want to be able to associate 10 or more different categories with another 50.

Lets say then I can look group articles by catA and sub B or cat B and sub A

I have hotels and restaurants in all countries. Want to display by country all hotels and restaurants and vice versa with hotels all countries and restaurants all countries...

How can I approach this? My idea is another table duplicating categories..? How do I program it into the module?

Any brave souls?

Ok, I guess I over did it with the question I even got confused after I read it...

Basically I have hotels, restaurants and bars for several countries. I would like to group results by venue (hotels, etc..) and by country as well.

Now, that was easier... Please help. At least tell me If my case is lost here in the forum.

E.

The wf_links module (found at http://www.wf-projects.com) has multi-category features, which means you can add a link to more the one category. That may be the closest thing you want, as there is no global category system for XOOPS -yet (working on it for XOOPS 2.4, most likely).

Herko

I don't use the AMS module, but it's relatively easy to with an sql query.
let's say a database table 'joints' with 'country', 'hotel', 'restaurant' rows.
you want to look up all hotels in Brazil, you do:

...
echo "BRAZIL";

$result = mysql_query("SELECT hotel FROM ".$xoopsDB->prefix("joints")." WHERE country='BRAZIL'");
while($row = mysql_fetch_array($result))
{

$hotel = mysql_result($result, "hotel");

echo "$hotel";
}
...

you want to look up all hotels in all countries, you do:

...

$result = mysql_query("SELECT * FROM ".$xoopsDB->prefix("joints").");
while($row = mysql_fetch_array($result))
{
$country = mysql_result($result, "country");
$hotel = mysql_result($result, "hotel");

echo "$country";
echo "$hotel";
}
...

this code seq may have bugs in it.

the "article" module, which was planned as "wfsection 3", has the cross-category ability

Its public test version will be released once XOOPS 2.2 is done
right now you can see a very brief demo at
https://xoops.org.cn/modules/article/