How can I make links sql ignore "the" in link titles. For example, I would like the link The boarderforum to be listed with the "B's" and not the "T's". I couldn't find any discussions on this. Any advise? Thanks in advance

Within what pages? Category pages? Search results?
========================================
Buh Bye!

Cheers,
Me

Links within categories. Now the sort is alphabetical by title. I would like it alphabetical by title, ignoring "the"

Thanks

Lennie:



What I did- it is a little labor intensive to get started, but works- is to add a new filed, called "Sort". Then copy the category names to sort (do that in the Monitor), then edit all the ones with the "The" in them so they do not!



Then, in setup, just change the column to sort by!



dave
dave

Big Cartoon DataBase
Big Comic Book DataBase

Hi,

Dave has a good idea. It's not going to be straightforward, as Links SQL has MySQL sort the results for speed and efficency reasons. Anothing way you could do it is have a checkbox called 'AddThe' which is checked for links that start with The, and blank otherwise. Then remove The from new links, and modify the template:

<%if AddThe%>The <%endif%><%Title%>

Might be a bit more efficent as you aren't repeating the title, but it's still a little labour intensive.

Cheers,

Alex
--
Gossamer Threads Inc.