Page 1 of 1

WTB: Search engine for PHP MSSQL

Posted: Wed Jan 08, 2003 12:44 pm
by dkizerian
Hi,
I'm looking for a search engine to access an MSSQL DB from PHP. I only need to go through articles in one table, so i don't really think I need to fancy of one.
Any help will be greatly apreciated

Dave

SqlServer etc.

Posted: Wed Jan 08, 2003 11:37 pm
by fractalvibes
Your best "Search Engine" in this case is none other than SQL.

You are only needing to query 1 table, so perhaps give them options to
choose to search by date, author, or text within the article, and any other relevant criteria you are storing in the table.

Handle the search in your PHP code via sql queries using appropriate wildcards like:
......WHERE AUTHOR LIKE '" . txtAuthorName . "%'"

You may want to have your DBA examine the table and see where additional indices may speed up the searches.

Phil J.