I have "Links sql" version 2.0.5 and i am trying to display under each link that the search by keywords displays the category it belongs to underneith.

I am not interested in grouping the links by category in the keyword result page but I am in displaying after each link separately the category it belongs to.

Obviously i wouldn´t want this to happen in the links displayed by Category search.

I have looked trough previous posts but I only find the way of doing this for Links 2.0. (I have Links sql 2.05).

Any help on this issue is appreciated.

Thank you...

Hi,

Hmm, you would need a global for this:

category_info =>
So if you put: <%category_info%>, it will return the name of the category that link is in.

Cheers,

Alex
--
Gossamer Threads Inc.

Thanks for the code, but it doesn´t display anything in my search results.

You are probably thinking if i did it right. I created the category_info in template globals and added to link.html the tag <%category_info%>

It doesn´t give a tag error but it doesn´t show anything either.
I was using the correct template set as well.

Any ideas why?

Sorry to reply to my own posts every 5 minutes but
I have just figured out the way round it at my style
(remember i am not a programmer so
please don´t laugh).

I have found 2 codes in the forum.

The first one i have modifed myself so it substitutes
the "&" and the "," with "_" . (to get the hyperlinks
right). This part of the code only acts as I hyperlink
to the correct category. In the a href I inserted the
word category so that the users don´t view the ugly
url with all of the "___" instead of the characters ","
and "&".



The second one is the part that displays the text of
the category with no hyperlink. Just the name of the
category in a understandable way.



With the 2 pieces of code i have created to global
templates and inserted them into links.html.


E.g.
http://


Thanks for the help.

It´s me again.

Just one more thing.

In the links.html I have put the template globals tags under the <%if query%> tag. This way i don´t get the categories appearing under the links when somebody already is searching by category.

Great forum when you know what you are looking for !!!

I use the following code as a global successfully:

Name:

display_category

Code:

sub {
my $tag = shift;

my $table = $DB->table ('CatLinks');
my $sth = $table->select ( { LinkID => $tag->{ID} }, ['CategoryID'] );

my $catID = $sth->fetchrow();

my $cattable = $DB->table('Category');
my $sth2 = $cattable->select ( { ID => $catID }, ['Full_Name'] );

my $name = $sth2->fetchrow_array;
my $clean_name = $cattable->as_url($name);
my $url = "<a href=\"" . $CFG->{build_root_url} . "/" . $clean_name . '/' . $CFG->{build_index} . "\">" . $name . "</a>";

return $url;
}

Then in the link.html template I include:

<%if query%>
<%display_category%>
<%endif%>

Make sure that in the Setup for Search Options you designate:

build_search_gb

with "No" selected.

This should work fine.

-jw