Hello,

I need a search facility for my site but i don't know where to begin. It's a serach facility for looking for jobs, and i'm storing the information in the database. I need it to be similar to http://www.jobserve.com ,where i can search with one word or multiple words.

Any help would be appreciated, thank you.

Thanks stu2k1(Stuart)

Helol,

This doesn't sound like a client side Javascript question - but anyway, you're storing the data in a database...so you should be able to query the appropriate field in the database:

select mykey from mytable where myfield like "%keyword%";

will select all the records from table mytable which contain the keyword anywhere in the myfield field.

Multiple searches - just add 'and myfield like "%keyword2%"'


Does this help - or am I misunderstanding the question?

Piglet is correct you are looking for a serverside script in whatever language your server is set up in to run a dBase search like the one you want.

Try ColdFusion ASP PHP forum.

Hers a coldfusion example

<cfquery name="logdata" datasource="deleted" dbtype="ODBC" username="reased" password="blooped" dbserver="localhost" dbname="myDb">
SELECT * FROM wt_logs WHERE wt_remote_country LIKE '%#keyword#%'
</cfquery>