Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Search feature for additional table in database?

Quote Reply
Search feature for additional table in database?
Hello,

We have set-up addition tables in our mysql database. Is it possible to make them searchable through the built in search feature in link sql? Additionally, is it possible to make the html on our site searchable through linksql search feature?

Sukh
Quote Reply
Re: [schugh2k] Search feature for additional table in database? In reply to
Something like this?

search.cgi?query=&Extra_Field=test&MyCount_Field-gt=50

This would match any links with 'Extra_Field' as 'test', and 'MyCount_Field' is greater than 50.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [schugh2k] Search feature for additional table in database? In reply to
Searching other tables:

This is not at all straightforward. It involves writing a plugin - can be done but it depends how happy you are with perl, LinksSQL and writing plugins. You may need to ask for this as a custom mod.

As for searching the rest of the html on your site - this would be possible as above if the pages are created from sql tables. However, it may be easier to use a site search tool instead.
Quote Reply
Re: [afinlr] Search feature for additional table in database? In reply to
Thanks for the info guys.

We will look into picking up a site search tool from somewhere. Do you have any suggestions?

Thanks so much,
Sukh