PHP, MySQL easy quick santax question

[anthonydamasco]

Really simple

I have 2 columns in a table that I want people to be able to search from

here is my php

[code=php:0]

$result = mysql_query("SELECT * FROM employees WHERE firstname or lastname LIKE '%$search%'");

[/code]

i know "or" is wrong, because its only searching the "lastname" column, what is the correct santax?

[ober]

$result = mysql_query("SELECT * FROM employees WHERE firstname LIKE '%$search%' OR lastname LIKE '%$search%'");

OR is correct.

[anthonydamasco]

well the way i used it wasnt, lol, thank you