Re: [PHP] Dynamic menu not passing value to PHP?

SELECT * FROM inventory WHERE category='$sltCat'"; } else { $query_rsCat="SELECT * FROM inventory WHERE item_name LIKE '%$txtSearch%'"; } to circumvent this and it worked.. Thanks Janet for pointing this out...and thanks all for the help Dennis "

[PHP] Dynamic menu not passing value to PHP?

Hi, I'm trying to create a page where a user can choose to view products by category by selecting a drop down menu or he can choose to do a search against the item name. The script seems to work but I'm puzzled cos the mysql query seems to be querying all the category while it is suppose to match