Hi Sondra,

thanks for the donation offer... perhaps I should replace those under-performing Google ads in the right column with a donate button? Sounds like a good idea.

Regarding Mosets tree - can you be a bit more specific about the URL for the page, and the exact column names in the 2 tables you mentioned? Which of the tables has a column that matches the value in the URL? (and which URL parameter does it match)?

Cheers,
Stephen

OK, makes sense.

Try this:

if ($option == 'com_multisites' and JRequest::getVar('task') == 'viewlink') {
  $link = JRequest::getInt('link_id',0);
  $query = 'select cat_id from #__STMaster_mt_cl where link_id = $link;';
  $db->setQuery( $query, 0, 1 );
  $row = $db->loadObject();
  $cat_id = @$row->cat_id;
  if ($cat_id == 55) return 101; // module 101 for category 55
  // add more as appropriate
}

Hey Stephen,

I have just made my way to utilizing the code you provide above, however, it isn't working.  I thought I had found the problem with the mtree as opposed to multisites, but I am still unable to retrieve a cat_id value.

I'm using the following just to determine where the problem is and I'm not getting any value to display at all as the $cat_id but the $linkid is displaying correctly.  No error messages, just no $cat_id.

if ($option == 'com_mtree' and JRequest::getVar('task') == 'viewlink') {
  $link = JRequest::getInt('link_id',0);
  $query = 'select cat_id from u62_STmaster_mt_cl where link_id = $link;';
  $db->setQuery( $query, 0, 1 );
  $row = $db->loadObject();
  $cat_id = @$row->cat_id;
  echo "welcome to";
  echo $cat_id;
  echo $link;
}

Also, is there a way to use a global variable for the site prefix so that I don't have to hard code it??? 

Thanks so much!

Sondra

Ok with the variable &link not being defined in Navicat, I used the following sql for the query

select cat_id from u62_STmaster_mt_cl where link_id = '351'

and it returned

1050

which is correct.  Any ideas????

(just realised that it was me that gave you the wrong code to start with... sorrrrry!)