Search?

[dan958]

Hey, i am having trouble setting up a search for my website.


I have different fields in my database, the ones i need for this function are 'id', 'First name', 'last name' and 'username'

I want it to you search for either the username, first name AND/OR lastname (obviously you can use both for a more accurate search)

Once you have sent the form i want it to change to a page where it will display all the data from what you searched and a link to there profile (the unique profile code is already done)


e.g.

You search this:

John smith

it will display:


Name: John smith
Username: Johnny
Click here to go to profile



OR



You search this:

Johnny

it displays

Name: John smith
Username: Johnny
Click here to go to profile


Bare in mine that usernames are unique.