php and mysql search

[sdreams]

hello,

my website is mainly regarding vacation rentals of all kind in Spain. All accommodations are added manually and then shown in their respective province ordered alphabetically by town.

I would like to offer a search function to the visitors and hope it is ok to show a link to a page (see information in the center) I prepared in order to explain what I would like to set up:

http://www.spaindreams.com/eng/search.htm


I suppose this search could be done with php and mysql or maybe even with some kind of other program.
My web runs on Linux and PHP and Mysql are installed.

Help on this would be very much appreciated as I have been looking quite a lot for information, but....

Thanks for reading my message

 

[KCamel]

Is all data stored in MySQL database? what do you want to search engine to do? give me more details and i can post for you the code you need

 

[Equinox]

Ok, I know this post was from quite a while ago but I thought I'd help out anyway.

Most Forum systems avaliable, now offer facilities whereby you can serach the data that was input into the system with relative ease. Take this vBulletin for example: You can search for most words, except maybe words lik 'it', 'was', 'and'...etc.

This is made possible by a PHP code which is executed when the post is first made. Words other than those that have been excluded are input into a database individually (along with their corresponding Titles and URLs) and can then be searched for easily by a simple SQL command : FETCH * FROM dictionary WHERE word="$search" or some such...

A good example of this simple but effective system can be found in the PHPbb source code.

I know this thread is old, but maybe someone else might find this helpful!
~Equinox