3 and $_REQUEST['f'] != "First Name")
{ if (false !== strpos($_REQUEST['f'], "%"))
{ // pre-wild-carded
$fArgs[] = $_REQUEST['f'];
}
else if (false !== strpos($_REQUEST['f'], "!"))
{ // pre-wild-carded
$fArgs[] = str_replace("!", "", $_REQUEST['f']);
}
else
{
$sl = strlen($_REQUEST['f']);
$_REQUEST['f'] = strtolower($_REQUEST['f']);
$fArgs[] = padRef($_REQUEST['f']);
$fArgs[] = "%".substr($_REQUEST['f'], 1, $sl);
$fArgs[] = substr($_REQUEST['f'], 0, ($sl - 1))."%";
for ($i = 1; $i < ($sl - 1); $i++)
{ $fArgs[] = "%".substr($_REQUEST['f'], 0, $i)."%".substr($_REQUEST['f'], ($i + 1))."%";
}
}
foreach ($fArgs as $v)
{ if ($fq)
$fq .= " or ";
$fq .= "`fName`like '$v'";
}
}
if (!empty($_REQUEST['l']) and strlen($_REQUEST['l']) > 3 and $_REQUEST['l'] != "Business or Last Name")
{ if (false !== strpos($_REQUEST['l'], "%"))
{ // pre-wild-carded
$lArgs[] = $_REQUEST['l'];
}
else if (false !== strpos($_REQUEST['l'], "!"))
{ // pre-wild-carded
$fArgs[] = str_replace("!", "", $_REQUEST['l']);
}
else
{
$sl = strlen($_REQUEST['l']);
$_REQUEST['l'] = strtolower($_REQUEST['l']);
$lArgs[] = padRef($_REQUEST['l']);
$lArgs[] = "%".substr($_REQUEST['l'], 1, $sl);
$lArgs[] = substr($_REQUEST['l'], 0, ($sl - 1))."%";
for ($i = 1; $i < ($sl - 1); $i++)
{ $lArgs[] = "%".substr($_REQUEST['l'], 0, $i)."%".substr($_REQUEST['l'], ($i + 1))."%";
}
}
foreach ($lArgs as $v)
{ if ($lq)
$lq .= " or ";
$lq .= "`lName`like '$v'";
}
}
if (empty($fq) and empty($lq))
{ // no query - close dialogue
echo " \n";
}
else if ($fq and $lq)
$q = "($fq) and ($lq)";
else if ($fq)
$q = $fq;
else if ($lq)
$q = $lq;
echo "\n";
$cList = mysql_query("select * from clientdat where $q group by `cCode` order by lName,fName,city");
$nRows = mysql_num_rows($cList);
if ($nRows)
{ if ($nRows > 8)
$nRows = 320;
else
$nRows = 32 * $nRows;
echo " \n";
while ($c = mysql_fetch_assoc($cList))
{ echo "".fixName($c['fName'], $c['lName']).", {$c['city']}
\n";
}
echo "None of these (Continue)
\n";
}
else
{
echo " \n";
}
?>