Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Can Search in Glink be modified to search by combinations of column values

Quote Reply
Can Search in Glink be modified to search by combinations of column values
Can Glinks be modified to allow the user to search for a combination of values from different columns of Links table; something similar to classifieds or real estate sites where the user is able, for example, to specify values from different pull-down menus where each pull-down menu presents a column from Links table.

something like:

Search:
Type: (House, Apartment)
Rooms: 1,2,3,4,5,6
Floor: 1,2,3
City: List of cities
State: List of states
...
etc.

Thanks
Mark
Quote Reply
Re: [Mark2] Can Search in Glink be modified to search by combinations of column values In reply to
Hi,

Something like this should work:

search.cgi?query=*;Rooms=2;City=bla

You can also do quite cool stuff like:

Rooms-gt=2 , which would look for listings with "Rooms" great than 2 rooms.

Hope that helps.

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: [Andy] Can Search in Glink be modified to search by combinations of column values In reply to
Aaaah.. I see.. thanks much Andy...
So now I can build my own set of pull-down menus with my own values and when user clicks on [Search] I will pass these values to the URL....

thanks much..
Mark
Quote Reply
Re: [Mark2] Can Search in Glink be modified to search by combinations of column values In reply to
Hi,

No problem :)

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: [Andy] Can Search in Glink be modified to search by combinations of column values In reply to
Hello again...
I am trying to have more search options into the search form template...
So what I did, I added the following:

Code:
<div class="row searchoption clear">
<label for="Country" class="name">Country:</label>
<div class="value">
<input type="text" id="Country" name="Country" class="text" />
</div>
</div>

But when I search now both fileds (query and country), I am not getting any results...
but when I search each one without filling the other, I get the right results.
I am trying to search for ... newspaper name & country name at the same time...
any changes?

Thanks again
Mark
Quote Reply
Re: [Mark2] Can Search in Glink be modified to search by combinations of column values In reply to
What is the URL query you are using?

i.e search.cgi?query.xxx&whatever_else

?

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: [Andy] Can Search in Glink be modified to search by combinations of column values In reply to
I did not touch the query...
Code:
it still says: ".../scripts/search.cgi"
But when I enter data in fiels:

SEARCH: New York Times
COUNTRY: USA

I, automatically, get the following URL that yield no output..
Code:
...scripts/search.cgi?query=New+York+Times&Country=USA&bool=and&substring=0&mh=10
do I have to touch the search.cgi query

Thanks
Mark

Last edited by:

Mark2: Mar 21, 2011, 7:15 AM
Quote Reply
Re: [Mark2] Can Search in Glink be modified to search by combinations of column values In reply to
Hi,

So if you load:

scripts/search.cgi?Country=USA&bool=and&substring=0&mh=10

..or:

scripts/search.cgi?query=New+York+Times&bool=and&substring=0&mh=10

..both of these give results... but NOT when you use them both in the same query?

Do you know what "indexing" type you are using for your tables? (you can check it in Database > Links > Properties, and then look for "Indexing Scheme" at the bottom of the page.

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: [Andy] Can Search in Glink be modified to search by combinations of column values In reply to
That is right... Each search alone yields results, but not both together...
I am using the default search index "NONINDEXED"

Thanks
Mark again ;)

Last edited by:

Mark2: Mar 21, 2011, 7:22 AM
Quote Reply
Re: [Mark2] Can Search in Glink be modified to search by combinations of column values In reply to
Mmm ok, if you wanna send over GLinks admin panel + FTP access, I'll try and take a look at this for you this evening. Bit busy at the moment with other stuff - but I'll try and do it in about 3-4 hours, when I finish my main work Smile

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: [Andy] Can Search in Glink be modified to search by combinations of column values In reply to
Thanks much Andy.. I will let you know..
Mark