vb.org Archive - forumlist while

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - forumlist while (https://vborg.vbsupport.ru/showthread.php?t=67533)

sabret00the

07-23-2004 02:54 PM

forumlist while

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

07-23-2004 03:24 PM

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:

Code:

      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

07-23-2004 03:55 PM

you're right, it's not returrning nothing :(

i don't understand why

sabret00the

07-23-2004 03:57 PM

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

Dean C

07-23-2004 03:58 PM

Oh dear - I hate it when that happens ;)

All times are GMT. The time now is 01:11 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01083 seconds Memory Usage 1,725KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: