Time:
Scotland: Fri, 8:42 pm
Rhode Island: Fri, 3:42 pm
Florida: Fri, 3:42 pm
New Mexico: Fri, 1:42 pm
California: Fri, 12:42 pm

Click here to visit Livelife365.com

Click here to visit nmdarts.com



Buy this Ad Space.

180px wide.

Please get in touch with KH@ if you are interested and make an offer.

CLICK HERE TO GET AUCTION BAR NOW
US$10 per year - Save $100s!
The Fabulously Unfair
WebX Auction Bar. For Ebay etc.
Ro-Sham-Bo the opposition. Laugh like Eric Cartman when you win! CLICK HERE NOW!


More information and sign-up.

WebXpertz Hosting.
Custom fit from $5pm. PHP/MySQL
You'll save money, we'll save money. Seems fair to me. Interested? If so Please PM me here and tell me what you need. Thanks!


Please click here for more information

For continued disscussion on this topic : Search facility


stu2k1
04-11-2002, 01:50 PM
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)

piglet
04-11-2002, 02:06 PM
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?

KH@
04-11-2002, 04:52 PM
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>