Simple SQL Search Query

Hi...

I need to setup a search section for my db.

Search box, to search for name, category, image and display the results:

As the name above the image and the category below the image.

I know it's a lot to ask but I've been trying for 6/7 hours and I've got nowhere!

Please help!

Scott.

 

$query = "SELECT * FROM {$table} WHERE {$field} LIKE '%{$keyword}%'";

 

Thanks, how would I intergrate that into a search box though?

I'm useless with PHP & SQL, that's why it's been taking so long.

Scott.