Search results

I think you need paranthasis like this: AND (`Author` LIKE '%" . $name . "%' OR `title` LIKE '%" . $name . "%') AND 'lyrics' ... The OR statement in the original sql query will bring up title LIKE %$name% whether the songno matches or not.