Search database and display results

I have a db that has 7 different manufacturers. I would like to be able to search the table on the side that has mfg's and have the results displayed on my page. I am having trouble with picking a mfg. and sending the info and displaying it.

Hello,

It's very hard to help if we can't see your project, I suggest you show what you've done (screenshots) and your database structure. Also, is mfg = manufacturer name?