Search function help.

[Anon]

Okay, I need to construct a search function that can search a database of user names for relavent users. It needs to allow & for AND's and " " for OR's. The problem is, I have no idea how I would do that!

Example:

Users - Dark Phoenix, Test, Joker

User inputs "Dark".

Should list in the following order:
Dark Phoenix
Joker
Test

Users - Dark Phoenix, Test, Joe Pho

User inputs "Pho".

Should list in the following order:
Dark Phoenix
Joe Pho
Test

[pnoeric]

The '%' character in SQL is the wildcard, so just search for the user's input surrounded by '%" characters:

$sql = "SELECT username IN users WHERE username = '%$findme%';"

More than you ever wanted to know about this: note that if they put in more than one word, you will want to explode the input on spaces and commas, then drop the commas entirely, then build the SQL statement with ORs.

Hope that helps
-Eric