search list

[kevbev16]

sorry this has come from another topic but it revolves around the search engine on my sitehttp://www.bid4tackle.com/search.php

 

there are alot of problems with this page.

firstly, if you select the "buy it now" box and then type in "fox" at the search box to the left it shows all "fox" products independant of whether they are "buy it now". this also seems to be the case when you type in the item condition as "New" or "old" it will display all items called "fox" even though they are not that condition. this would suggest that it is searching for the name in the search box and ignoring and ticks that have been made in the "search options" section.

 

likewise if you search for price "0" to "£100" and also tick "buy it now" it will display all "buy it now" items despite not being in that price bracket.

 

finally, when you select the location box and tick the "worldwide" or "europe" box it does not show the UK for some reason. it is searching for the posting location rather than te users regestration area.

 

i understand there is loads there to do but if anyone could help me i would be very grateful

 

if($mode=="searchlist")
{
if($_REQUEST[chk]=="yes")
{
$sql="select * from placing_item_bid where  bid_starting_date <= now() and status='Active' and selling_method!='want_it_now' and selling_method!='ads' and ";
if($_REQUEST[chkitemspriced])
{
$chkitemspriced=$_REQUEST[chkitemspriced];
$max_cur=$_REQUEST[txtpricedfrom];
$min_cur=$_REQUEST[txtpricedto];
$sql.=" (min_bid_amount >= $max_cur and min_bid_amount <= $min_cur) and ";
}
if($_REQUEST[chkitemscondition])
{
$chkitemscondition=$_REQUEST[chkitemscondition];
$itmcnd=$_REQUEST[cboitemcondition];
$sql.=" item_specify=\"$itmcnd\"  and ";
}
if($_REQUEST[chkbuyitnow])
{
$chkbuyitnow=$_REQUEST[chkbuyitnow];
$show="buy";
$sql.=" selling_method='fix'  and ";
}
if($_REQUEST[chkitemslistedsingle])
{
$chkitemslistedsingle=$_REQUEST[chkitemslistedsingle];
$show="bid";
$sql.=" selling_method='Auction'  and ";
}
if($_REQUEST[chkitemslisteddouble])
{
$chkitemslisteddouble=$_REQUEST[chkitemslisteddouble];
$show="bid";
$sql.=" selling_method='dutch_auction'  and ";
}
if($_REQUEST[chklisted])
{
$show="bid";
$sql.=" payment_gateway=''  and ";
}
if($_REQUEST[chklocation])
{
$chklocation=$_REQUEST[chklocation];
$ship=$_REQUEST[cbolocation];
$show="bid";
if($ship==1)
{
$sql.=" shipping_route like \"%$ship%\" and ";
}
else
{
$sql.=" shipping_route like \"%$ship%\" and ";
}
}
}
$sql=rtrim($sql," and ")." and expire_date >=now()";
//echo $sql;
}

 

 

Kind regards,

Kevin

 

[attachment deleted by admin]