Search DB with Multiple Search Strings

[lilman]

I want to search my db's columns title and author. Here is the code I've written:

[code]$query = "SELECT * FROM bookcatalog WHERE title like \"%$title%\", author like \"%$author%\"";
$runquery=mysql_query($query) or die(mysql_error());[/code]

When I run it I get this error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' author like "%Isaac%"' at line 1

It worked fine until I added this part of the code [code], author like \"%$author%\"[/code]

Any help would be great!

[Psycho]

Replace the comma with either 'AND' or 'OR' (without the quotemarks) depending on what you want.

"SELECT * FROM bookcatalog WHERE title like \"%$title%\" AND author like \"%$author%\""

"SELECT * FROM bookcatalog WHERE title like \"%$title%\" OR author like \"%$author%\""