[Code Monkey]

Originally Posted by Antivirus

thanks Paul, this worked for me:

PHP Code:

$newsfids_q = $db->query_read
    ("
    SELECT forumid FROM " . TABLE_PREFIX . "forum 
    WHERE (parentid = " . $news_setup['artist_news_parent_forum_id'] . " 
    OR forumid = " . $news_setup['eclipse_news_forum_id'] . ")
    ");
while ($newsfid = mysql_fetch_array($newsfids_q))
{
    $forumids .= $newsfid['forumid'] . "," ;
}
$newsfeedforumids = $forumids; 


would there have been a better way to do it than above?

Yes there would be if you want to be fully integrated. Use vBulletins $db->fetch_array.

PHP Code:

$newsfids_q = $db->query_read
    ("
    SELECT forumid FROM " . TABLE_PREFIX . "forum 
    WHERE (parentid = " . $news_setup['artist_news_parent_forum_id'] . " 
    OR forumid = " . $news_setup['eclipse_news_forum_id'] . ")
    ");
while ($newsfid = $db->fetch_array($newsfids_q))
{
    $forumids .= $newsfid['forumid'] . "," ;
}
$newsfeedforumids = $forumids;