forumlist while

[sabret00the]

what am i doing wrong this won't work

PHP Code:

$forumlist=$DB_site->query_first("
                     SELECT * 
                     FROM forum 
                     WHERE threadcount > 0 
                  AND forumid NOT IN (11,16,42,46,47,1,13,38,53,90,92,95)
                  AND parentid NOT IN (2,10,13,19,70,16,33,24,49,53,79,96)
                     ORDER BY RAND()
                  "); 
 //                 $resultlatest = mysql_query($query,$db); 
  
$counted = 0;
  while ($forumlist_array = $DB_site->fetch_array($forumlist))
  {
      $forumlist_array['title'] = nl2br(stripslashes($forumlist_array['title']));
      $forumlist_array['description'] = nl2br(stripslashes($forumlist_array['description']));
      $forumlist_array['forumid'] = number_format($forumlist_array['forumid']);
      extract($forumlist_array);
                      
      eval('$siteindex_forumlistbit .= "' . fetch_template("siteindex_forumlistbit") . '";');
      $counted++;
  
      if ( $counted == 5 ) {
          break;
      }
  } 


the query works perfectly but it all goes wrong in the while

[CarCdr]

What do you mean "it all goes wrong..."

Perhaps you are getting no results from the query. Is the 'while' running at all? Check that you have some results with:

      if ($DB_site->num_rows($forumlist) == 0) {
          NO RESULTS CODE
      }

ps: I don't think you want to run 'number_format' on a forum ID.

[sabret00the]

you're right, it's not returrning nothing

i don't understand why

[sabret00the]

fixed it, had to change the query first to a query

[Dean C]

Oh dear - I hate it when that happens