basic while loop problem (admincp)

[sabret00the]

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]

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]

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