Simple Search Help Needed!

[Bradley_James]

Hey Guys-

 

I built a page where bands and musicians can submit their name, genre and website to a database that others can search.  I'm trying to figure out how to get my PHP code to search both by genre and band name.  Here's the line of code I'm referring to:

 

$query = "select * from Information where genre like \"%$trimmed%\"

  order by genre";

 

I assumed that I could add "OR" after "genre" and then type "bandname" after that, resulting in "where genre OR bandname like \%$trimmed\"  however, this doesn't work.  Any help would be appreciated!

 

-Brad

[premiso]

Check out this tutorial:

 

http://www.phpfreaks.com/tutorial/simple-sql-search

 

See if that helps ya.

[WebStyles]

try something like this:

 

$query = "select * from Information where genre like '%$trimmed%' or bandname like '%$trimmed%'  order by genre";

[Bradley_James]

You guys rock.  Works like a dream!  Thanks!