On Tuesday 17 June 2003 05:45, Dennis Martin Ong wrote:
Is there
something I've missed out cos it seems like the $sltCat which is suppose to
pass the selected option value when the form is submitted is not passing
the correct value,
So have you verified that it passes the value as expected
Got it sorted out now
$query_rsCat = SELECT * FROM inventory WHERE category='$sltCat' OR
item_name LIKE '%$txtSearch%';
This will select all the items if either $sltCat or $txtSearch is empty.
Janet
'%$txtSearch%' would always evaulate as '%%' in Mysql when the txtSearch
field is empty
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
3 matches
Mail list logo