Site search engine for mysql database

I have built a web site using php and mysql.
I currently holds around 3000 products with short description, long description, price, etc...

I need to setup a search facility so a visitor can search the database and then display all the details of that product.

Is there a script that I can download, or can somebody start me off in the right direction.

Thanks

John C

 

Google Search does it beautifully, but starts about $100 a year.

For free roll-your-own solution, check this out:

"Using PHP to search a MySQL database and return paged results"
http://www.designplace.org/scripts.php?page=1&c_id=25

Their tutorial looks pretty clean and adaptable.

 

it's not too hard to build your own, especially on a small database like that. I suggest you take a little time to read the w3schools tuturial which is great: http://www.w3schools.com/sql/default.asp and you will be able to do this on your own in a few days.

 

Another option would be to use google custom search to run a search just on your site - you won't have control over how the results look, etc - but it's an option.

 

Will that work if your pages aren't in google's index?

 

Nope, of course it wont work.