Help with queries

[harmor19]

I have two table; one is for categories, the other for links.
What I want to do is show the category then show the relative links.
Basically I would like to work like categories and forums.
You have the "News And Announcements" category then follows the forums.

[Paul M]

So what exactly is your question ?

[harmor19]

I am upgrading my "Custom Navbar Links" hack and I would like to add seperators.

I have two table; custom_links_cat and custom_droplinks

custom_links_cat

• catid
• title
• link_perms

custom_droplinks

• linkid
• catid
• url
• name
• ....

My hack is like "Quick Links" but user defined. Hopefully the image will explain what I want.

[harmor19]

I need help. I got it to do what I wanted but it only gets the first catid it comes across instead of all of them.

PHP Code:

$getcats = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "custom_links_cat");
     while($cat = $db->fetch_array($getcats))
     {
       
        $getdroplinks = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "custom_droplinks WHERE catid='$cat[catid]' ");
        while($dlink = $db->fetch_array($getdroplinks))
        {    
           $custom_droplinks .= "<tr><td class='thead'>".$cat['title']."</td></tr>
                     <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') . '";');
        }
      } 


[harmor19]

Please help.

[harmor19]

what's wrong with this code

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) 
    WHERE clc.catid=cdl.catid ORDER BY clc.catid ASC");

    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 = "";
        }
        
        $dlink['link_perms'] = explode(",", $dlink['link_perms']);

if(in_array($vbulletin->userinfo['usergroupid'], $dlink['link_perms']) )
{ 
    $custom_droplinks .= "<tr><td class='thead'>".$dlink['title']."</td></tr>    
    <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') . '";');
    } 


Screenshot of what it's producing below

[Paul M]

Everytime you loop round (for each record) the code adds the header and the link, there is nothing to check if the header is the same as the previous record.

[harmor19]

So how would I check it?

[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']; 
    } 


[ShadyB]

Can I rename the title on the navbar saying Extras?