[phpdoctor]

Hi guys,

Im getting ready to create a search feature for this site...
It needs to search multiple tables and sort by relevance

Do you know any guides or have any tips/ideas?

[Jcbones]

Yes, plenty of guides, plenty of ideas...

[phpdoctor]

Thanks, that helped alot.

[Jcbones]

Yep, I sent about as much info as you did.


Edit: database type would be a good start.

[phpdoctor]

Ye sorry, MySql 5.0.45

Im wanting to search two tables called products & articles. Possibly more.
I need to search each table for some keywords then display any found record
in order of relevance.

When displaying I can render each item as a product or an article.
Do you think I need to search each table separately and then join them together?

Havent done any ordering by relevance before... Maybe if a keyword is found
in a field it adds to a score, then the records can be ordered by this score?

Sorry for being abit rude also >.>

Lex

[wirehopper]

MySQL :: MySQL 5.1 Reference Manual :: 11.8 Full-Text Search Functions

MySQL :: MySQL 5.1 Reference Manual :: 3.3.4.7 Pattern Matching

MySQL :: MySQL 5.1 Reference Manual :: 11.4.2 Regular Expressions