Help with queries

[harmor19]

I finally got it.
If you people didn't help because you thought I wasn't trying then you all wrong

PHP Code:

$getdroplinks = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "custom_links_cat clc
LEFT JOIN " . TABLE_PREFIX . "custom_droplinks cdl ON (clc.catid=cdl.catid) "); 

$prev_cat = '0'; 

while($dlink = $db->fetch_array($getdroplinks))
{
    
       if($dlink['new_window'] == 1)
       {
         $new = "_blank";
        }
        else
        {
         $new = "";
        }
        
        if(!empty($dlink['image']))
        {
          $img = "<img src='".$dlink['image']."' width='16' height='16' />";
        }
        else
        {
          $img = "";
        }
        
        if($dlink['catid'] != $prev_cat)
        {
            $custom_droplinks .= "<tr><td class='thead'>".$dlink['title']."</td></tr>";
        }
        
        $dlink['link_perms'] = explode(",", $dlink['link_perms']);


            if(in_array($vbulletin->userinfo['usergroupid'], $dlink['link_perms']) )
            { 
                $custom_droplinks .= "$header
                <tr><td class='vbmenu_option'>$img<a href='".$dlink['url']."' target='$new' title='".$dlink['alt']."'>".$dlink['name']."</a></td></tr>";
            }
                            
        eval('&$custom_droplinks = "' . fetch_template('custom_droplinks') . '";');
        
        $prev_cat = $dlink['catid']; 
    }