[RESOLVED] Matching several variables?

[Undrium]

$sql .= "MATCH(name) AGAINST ('$search')

I want the searcher to be able to search another variable too but $name. The other one would be $surname. How do I make it so people can search both words within the same search function?

Thanks,

Undrium

[bradgrafelman]

Create a fulltext index that includes both columns, and then use "MATCH(name,surname)" in your query.

EDIT: For more information, try reading the manual.

[Undrium]

Thanks for the help, bradgrafelman!

Didn't know you had to create those fulltext indexes together.