vb.org Archive - Trying to list ALL entries in 1 column

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

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

- - Trying to list ALL entries in 1 column (https://vborg.vbsupport.ru/showthread.php?t=108533)

Zelda-King

02-21-2006 02:05 PM

Trying to list ALL entries in 1 column

I've been attempting to setup a page that includes the display of ALL v3 arcade games (just the titles as an easy reference to what is installed).

I'm playing with the following query for it at the moment;

Code:

// Gamecount list

                $list = $db->query_read("SELECT arcade_games.title FROM " . TABLE_PREFIX . "arcade_games AS arcade_games WHERE gameid IS NOT NULL GROUP BY arcade_games.title ORDER BY title ASC ");

            while ($glist = $db->fetch_array($list)) {

            eval('print_output("' . fetch_template('arcade_list') . '");');

However, when I bring it up in the template with $glist[title], only the first entry is shown. Any insight as to what I'm lacking?

Marco van Herwaarden

02-21-2006 02:18 PM

In general you do something like:

PHP Code:


		
			
// Process a list and display it using templates
$list = $db->query_read("SELECT ....");
while ($item = $db->fetch_array($list))
{
    // Build $mylistbits variable with the information of all returned rows
    // The 'mylistbit' template will contain 1 line with the information of $item we want (and line formatting/extra text)
    eval('$mylistbits .= "' . fetch_template('mylistbit') . '";');
}
 
// Now spit out the final template
// The template 'mypage' will contai header/footer/etc.. ad 1 line containing '$mylistbits'
eval('print_output("' . fetch_template('mypage') . '");');

Zelda-King

02-21-2006 02:49 PM

Sorted! Thanks a lot for that example. I had a major breakthrough in how that all works together looking at that.

All times are GMT. The time now is 05:15 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04103 seconds Memory Usage 1,713KB 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 (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: