vb.org Archive - Help Creating Dynamic category list!

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

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

- - Help Creating Dynamic category list! (https://vborg.vbsupport.ru/showthread.php?t=64026)

Help Creating Dynamic category list!

PHP Code:


		
			
  
  $cathandle = mysql_query("SELECT * FROM amartincats ORDER BY id ASC");
  
  $count = mysql_num_rows($cathandle);
  while($count>0)
  {
  $catdata = mysql_fetch_array($cathandle);//get category data
  $catstitle = $catdata[name];
  
  //loop through articles of given category
  $ahandle = mysql_query("SELECT id, subject, subject_2 FROM amartin WHERE category  = '".$catdata[id]."' ORDER BY subject ASC");
  $acount = mysql_num_rows($ahandle);
  while($acount>0)
  {
  $adata = mysql_fetch_array($ahandle);
  
  $populars['subject'] = $adata[subject]; 
  $populars['id'] = $adata[id]; 
  $populars['subject_2'] = $adata[subject_2];
          
  
  $acount--;
  }//end article loop
  
  eval("\$cats1bit .= \"".fetch_template('article_list_bit')."\";");
  //echo($cats1bit); //do whatever has to be done to put in in the template :)
  unset($cats1bit);
  
  $count--;
  
  eval("\$article[cat1] .= \"".fetch_template('article_cat1')."\";");
  }
  //end main cat loop

This is for my article system that I'm preparing to release.... I just can't seem to grab the data and cycle through the lists properly :(

Looks to me like your code has a major drawback. You don't need to run so many queries. Try one or two queries and loop through the result set(s) (you're only extracting one of the tuples from each query) instead of running multiple queries. Hope this helps.

Example:

PHP Code:


		
			
$result = mysql_query($query, $dblink);

while($row = mysql_fetch_array($result))  

{ 

    $populars[$row['id']]['subject'] = $row['subject'];

    $populars[$row['id']]['subject_2'] = $row['subject_2'];

    .... 

}

could you give me some more info about that?

My current version I'm actually naming all the categories :(

PHP Code:


		
			
   
 $cat1 =    $DB_site->query("SELECT id, subject, subject_2 FROM amartin WHERE category = 1 ORDER BY subject ASC");    
 while($category1 = $DB_site->fetch_array($cat1)) {$populars['subject'] = $category1['subject']; $populars['id'] = $category1['id']; $populars['subject_2'] = $category1['subject_2']; 
  eval("\$cats1bit .= \"".fetch_template('article_list_bit')."\";");} 
  eval("\$article[cat1] = \"".fetch_template('article_cat1')."\";"); $DB_site->free_result($cat1);
  
 $cat2 = $DB_site->query("SELECT id, subject, subject_2 FROM amartin WHERE category = 2 ORDER BY subject ASC"); while($category2 = $DB_site->fetch_array($cat2)) {$populars['subject'] = $category2['subject']; $populars['id'] = $category2['id']; $populars['subject_2'] = $category2['subject_2']; eval("\$cats2bit .= \"".fetch_template('article_list_bit')."\";"); } eval("\$article[cat2] = \"".fetch_template('article_cat2')."\";"); $DB_site->free_result($cat2);

I don't really understand how to loop through them both at the same time. I'm still learning.... Trying to get my article system ready to release. It's the biggest project I've done to date.

Also whats the proper way to use unset?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01135 seconds Memory Usage 1,741KB 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 (3)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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: