Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Search custom tables

Quote Reply
Search custom tables
Hi,

I've been stuck on this for a few days now - I can't see what could be wrong so I'm hoping some fresh eyes might spot a stupid mistake.

I've added some custom tables to my setup and I'm trying to search them. One of them works and the other doesn't. I've set them both to internal indexing, I've rewritten the nph-index.cgi file so that it includes these two tables. I've checked in mysqlman that the Score_List and Word_List tables have both been added for both tables and have entries in them.

If I try searching using query_sth I get the correct number of results from hits but no results are returned for one of the tables. I know the code is ok because it works if I search for a particular LinkID just not for a query. I get the same result in the admin database editor using the indexed search - it says 'Your search returned 2 results' but doesn't print them.

Does anyone have any ideas what the problem might be?

Thanks, Laura.
The UK High Street
Subject Author Views Date
Thread Search custom tables afinlr 1357 Apr 11, 2003, 5:28 AM
Thread Re: [afinlr] Search custom tables
Alex 1279 Apr 11, 2003, 9:13 AM
Thread Re: [Alex] Search custom tables
afinlr 1279 Apr 11, 2003, 10:38 AM
Thread Re: [afinlr] Search custom tables
afinlr 1266 Apr 11, 2003, 12:21 PM
Thread Re: [afinlr] Search custom tables
afinlr 1231 Apr 17, 2003, 2:58 PM
Thread Re: [afinlr] Search custom tables
Alex 1250 Apr 17, 2003, 3:59 PM
Post Re: [Alex] Search custom tables
afinlr 1238 Apr 17, 2003, 4:11 PM