Page 1 of 1

php and mysql search

Posted: Mon Oct 11, 2004 3:52 pm
by 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:

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

Posted: Mon Oct 11, 2004 4:32 pm
by tim
MySQL has its own search features, which is fast and very powerful.

search for the command LIKE in the MySQL docs or search this forum for "search"

this has been discussed over n over again, and u could see some examples

very easy - none the less

mysql and php programming

Posted: Wed Oct 13, 2004 9:33 am
by sdreams
Thank you for your time.
Probably I will look for someone to set up some kind of search function

Posted: Wed Oct 13, 2004 11:27 am
by kettle_drum
Can easily get that done for you if you want. Just E-Mail me at contact [at] frozensheep [dot] com if your interested.

Posted: Wed Oct 13, 2004 5:51 pm
by tim
maybe I was misleading

this type of scipt is so simple

do it yourself, relish in your own self-pride plus you'll know it for future reference and you may need to edit it for future ordeals, so its best to do it yourself!

:D

Posted: Wed Oct 13, 2004 5:57 pm
by patrikG

search feature

Posted: Thu Oct 14, 2004 4:26 pm
by sdreams
thanks for showing some links. i will get into this.

i am new to all this and have read quite a lot before...but sometimes the more you read the more confusing it gets

Posted: Thu Oct 14, 2004 4:28 pm
by patrikG
:)

Posted: Sun Oct 17, 2004 4:05 pm
by MattF
In my experience a fulltext search will yield better results than a LIKE query.