이것때문에 코드가 너무 길어지네요..ㅜ
$category = $_REQUEST['category'];
$qry = "select url,name from editSS
where brand='".$name."' and category = '".$category."'
and '".$minprice."'<price and price<'".$maxprice."' ";
그냥 이런식으로 하면 될것이..
if($category == 'IS NOT NULL'){
$qry = "select url,name from editSS
where brand='".$name."' and category IS NOT NULL
and '".$minprice."'<price and price<'".$maxprice."' ";
}
else{
$qry = "select url,name from editSS
where brand='".$name."' and category = '".$category."'
and '".$minprice."'<price and price<'".$maxprice."' ";
}
...좀멍청한 코드인거 같아서 질문드려요.. 좀 알려주실분!!ㅎㅎ