vb.org Archive - basic while loop problem (admincp)

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

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

- - basic while loop problem (admincp) (https://vborg.vbsupport.ru/showthread.php?t=77319)

sabret00the

03-02-2005 10:56 AM

basic while loop problem (admincp)

this would normally work perfectly, but for some reason it won't i blame the modcp lol

PHP Code:


		
			
    $total = $DB_site->query("

            SELECT COUNT(*)

            FROM maf_application

    ");



//    $appcount = number_format($DB_site->num_rows($total));



    print_form_header();

    print_table_header('Applications Awaiting Consideration');



    if (!empty($total))

    {

        $appz=$DB_site->query("

            SELECT *

            FROM maf_application

            LEFT JOIN " . TABLE_PREFIX . "user ON (" . TABLE_PREFIX . "user.userid = maf_application.userid)

        ");



        $havegroups = false;



        while ($app=$DB_site->fetch_array($appz))

        {

            if ($havegroups)

            {

                print_description_row('<span class="smallfont">&nbsp;</span>', 0, 2, 'thead');

            }

            else

            {

                print_label_row('' . stripslashes($app['username']) . '\'s Application', '[<b><a href="maf_rateapp.php?s=' . $session[sessionhash] . '&do=rate&appid=' . $app[appid] . '">rate it</a></b>]');

            }

            $havegroups = "true";

        }

    }

what am i doing wrong?

Zero Tolerance

03-02-2005 11:28 AM

The problem isn't the loop, its your query, change it to this:

PHP Code:


		
			
        $appz=$DB_site->query(" 

            SELECT a.*,u.* 

            FROM maf_application a

            LEFT JOIN " . TABLE_PREFIX . "user u ON (u.userid = a.userid) 

        ");

- Zero Tolerance

sabret00the

03-02-2005 11:52 AM

neverworked so i got a little confidence and turned out the problem was the conditional :)

All times are GMT. The time now is 04:40 PM.

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