
|
|
error_reporting(0);
if(!$op)
$op="AND";
include "globals.php";
$con=odbc_connect($ServerName,$UserName,$Password);
$company=$_GET['company'];
$city=$_GET['city'];
$state=$_GET['state'];
$cat=$_GET['cat'];
$contact=$_GET['contact'];
$address=$_GET['address'];
$zip=$_GET['zip'];
if($address!="")
$address="%$address";
if (trim($keyword)=="")
{
$qq="Select COMPANY,CONTACT from weblist ";
$q="";
if(trim($city)!="")
{if($q!="") $q.=" $op "; $q.=" iif(isnull(city),' ',city) like '$city%' ";}
if(trim($state)!="")
{if($q!="") $q.=" $op ";$q.=" iif(isnull(state),' ',state) like '$state%'"; }
if(trim($cat)!="")
{if($q!="") $q.=" $op ";$q.=" iif(isnull(category),' ',category) like '$cat%' ";}
if(trim($company)!="")
{if($q!="") $q.=" $op ";$q.=" iif(isnull(company),' ',company) like '$company%' ";}
if(trim($contact)!="")
{if($q!="") $q.=" $op ";$q.=" iif(isnull(CONTACT),' ',CONTACT) like '$contact%' ";}
if(trim($address)!="")
{if($q!="") $q.=" $op ";$q.=" iif(isnull(ADDRESS1),' ',ADDRESS1)+' '+iif(isnull(ADDRESS2),' ',ADDRESS2) like '$address%'";}
if(trim($zip)!="")
{if($q!="") $q.=" $op ";$q.=" iif(isnull(zip),' ',zip) like '$zip%' ";}
if(trim($q)!="")
$q=$qq." where $q";
else
$q=$qq;
}
else
{
$q="Select * from weblist where iif(isnull(city),' ',city)+
' '+iif(isnull(state),' ',state)+' '+iif(isnull(category),' ',category)
+' '+iif(isnull(desc),' ',desc)+' '+iif(isnull(desc),' ',desc)
+' '+iif(isnull(url),' ',url)+' '+iif(isnull(url),' ',url)
+' '+iif(isnull(email),' ',email)+' '+iif(isnull(email),' ',email)
+' '+iif(isnull(company),' ',company)+' '+iif(isnull(CONTACT),' ',CONTACT)
+' '+iif(isnull(ADDRESS1),' ',ADDRESS1)+' '+iif(isnull(ADDRESS2),' ',ADDRESS2)
+' '+iif(isnull(zip),' ',zip) like '%$keyword%' ";
}
$res=odbc_do($con,$q);
$row=odbc_fetch_row($res);
if(!$row)
{
?>
exit;
}
?>
TOTAL RECORDS:
echo ($f);?>
   
|
|