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
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