Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

MYSQL Indexed Search Works on PHP but not CGI

Aug 13, 2002, 2:46 AM
Dafyyd
User (189 posts)
Aug 13, 2002, 2:46 AM
Post #1 of 5
Views: 1696
Shortcut
Quote Reply
MYSQL Indexed Search Works on PHP but not CGI
I have changed my indexing system to MYSQL, however, it returns results on the php version of the program and not on the cgi version. I am running Mysql 3.23.51, and LSQL 2.11. Does anyone know why this would be the case?



Thanks for your help.
Aug 13, 2002, 7:34 AM
Stealth
Veteran (17240 posts)
Stealth's avatar
Aug 13, 2002, 7:34 AM
Post #2 of 5
Views: 1612
Shortcut
Quote Reply
Re: [giovanni] MYSQL Indexed Search Works on PHP but not CGI In reply to
I believe another PHP user (may be Dan Kaplan) came across this problem before and reported it in this forum. You might be able to find the thread by searching for MySQL indexing PHP.
========================================
Buh Bye!

Cheers,
Me
Aug 13, 2002, 8:08 AM
Dafyyd
User (189 posts)
Aug 13, 2002, 8:08 AM
Post #3 of 5
Views: 1603
Shortcut
Quote Reply
Re: [Stealth] MYSQL Indexed Search Works on PHP but not CGI In reply to
Thanks for your help Stealth. Unfortunately, after trying a number of permutations on Dan Kaplan, indexing etc, I was unable to find the discussion that you mentioned or anything similar.
Aug 13, 2002, 8:10 AM
Paul
Veteran (19537 posts)
Aug 13, 2002, 8:10 AM
Post #4 of 5
Views: 1605
Shortcut
Quote Reply
Re: [giovanni] MYSQL Indexed Search Works on PHP but not CGI In reply to
MySQL indexing is really bad and can often give no results when there are or should be some. I recommend using internal indexing.
Aug 13, 2002, 11:02 AM
Dafyyd
User (189 posts)
Aug 13, 2002, 11:02 AM
Post #5 of 5
Views: 1628
Shortcut
Quote Reply
Re: [Paul] MYSQL Indexed Search Works on PHP but not CGI In reply to
Thanks for your help Paul. I will take your advice.

Do you think it would be worth upgrading to MYSQL 4 for a better search?