Please Help Me In This

Your request is somewhat vague. However, here is a start to what I think your request is.

Grab whatever was entered on a textbox on the website, send it to your database, and do a search/select against your database for whatever matches your search criteria (what was entered in the browser), return any matching results. There are obviously other things that need to be in place for this to function correctly. You provided very little information for one to give you detailed answers.

If this is a homework exercise, please post what you have done so far. The only way to succeed is to at least try.

@nic

I am not a DBA but you might want to try the following "down and dirty" technique:

1) have a DB with keywords that you think people will most likely search for.

2) Map these keywords to a URL and description.  In essence your DB will have at least 3 columns: keyword, URL, and Description

3) Capture the keyword in a textfied

4) Strip out all spaces and, if you are using PHP, use I blv removeslashes() (or whatever it is called)

5) query the DB with a "like" keyword (example: SELECT * FROM DB_NAME WHERE word LIKE keyword_goes_here).  If the keyword searched on exists, you spit out the necessary fields, else you say something like, "your search didn't return any results, please search for something else".  OR

6) Have results returned for similar keywords.  In this case, you modify your DB based on 1 and 2 above, to account for the similar words and return those similar word results to the user.

Again, I am not a DBA but that is one "down and dirty" way of going about it.

I guess SQL command like (SELECT * FROM Persons
WHERE City LIKE '%your search criteria%') OR  should come up with every thing that has the search criteria