[hooloovoo33]

I have recently been starting a new site, and on this site there is going to be a form where the user submits information about interests, and location, and other details. What i would like to do, is to be able to submit this info to database, and then automatically search that database, and come up with other users that have similar interests and such, perhaps rating it by a relevancy. I have seen this before in more than one place, but i have no idea how to go about creating it. Any help would be much appreciated.

-Zac A.

[2Dfruit]

inserting that data into the DB is easy, then all you'd have to do is pass on url variables that would act as a search.

eg
Name: John Doe
Interests: Shooting
Age: 20

submit to DB

create url
http://www.site.com/similar.php?inte...hooting&age=20

etc
etc

[hooloovoo33]

Hi,

thanks for the reply. I've done some research, and I think i understand how to submit this info to a database. What im not sure on, is how to go about searching the database with that information, and sorting it based on number of similar hits.

[datahound]

Look at SQL (Standard Query Language) this is how you interrogate the database.

SELECT * from USERS WHERE interest LIKE $interest and age LIKE $age ORDER BY date_joined

sort of thing