search facility

[martinkuria]

Hi,
I have a content management system, for my database driven website developed using php and postgresql but I don't know how to develop a search facility for it.

How do I go about it?.

I have seen database driven website developed using php and mysql and they have their built search facilities where can I learn to develop my customized search facility please do advice.

Kind Regards
Martin W. Kuria

[Khalid Ali]

I think it all comes to personal choice on how one would want to implement a logic.
Persnally here is what I'd (probably) do.
create a table with 2 cols in it
may be
1. url
2.keywords

and then populate these fields with appropriate keywords for each url and then just perform a simple search in the db with the search word entered by the user,
On the other hand you can complicate it so that you get the search str and match it with the contents of each file in your database...as I said there could be so many ways to implement it.