[SOLVED] php and mysql search

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
sdreams
Forum Newbie
Posts: 3
Joined: Mon Oct 11, 2004 3:50 pm

php and mysql search

Post 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
User avatar
tim
DevNet Resident
Posts: 1165
Joined: Thu Feb 12, 2004 7:19 pm
Location: ohio

Post 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
sdreams
Forum Newbie
Posts: 3
Joined: Mon Oct 11, 2004 3:50 pm

mysql and php programming

Post by sdreams »

Thank you for your time.
Probably I will look for someone to set up some kind of search function
kettle_drum
DevNet Resident
Posts: 1150
Joined: Sun Jul 20, 2003 9:25 pm
Location: West Yorkshire, England

Post 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.
User avatar
tim
DevNet Resident
Posts: 1165
Joined: Thu Feb 12, 2004 7:19 pm
Location: ohio

Post 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
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

sdreams
Forum Newbie
Posts: 3
Joined: Mon Oct 11, 2004 3:50 pm

search feature

Post 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
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

:)
MattF
Forum Contributor
Posts: 225
Joined: Sun May 19, 2002 9:58 am
Location: Sussex, UK

Post by MattF »

In my experience a fulltext search will yield better results than a LIKE query.
Post Reply