session_start(); require_once("config.inc.php");
secure_page("1");
include_once("template.php");
head('ajax');
?>
if (isset($_POST[find])){
$srch = $_POST[find];
$query = "SELECT * FROM `client` WHERE accountnbr LIKE '%".$srch."%' OR fname LIKE '".$srch."%' OR lname LIKE '".$srch."%' OR company LIKE '".$srch."%' OR address LIKE '".$srch."%' OR city LIKE '".$srch."%' OR state LIKE '".$srch."%' OR zip LIKE '".$srch."%' OR phone1 LIKE '".$srch."%' OR phone2 LIKE '".$srch."%' OR fax LIKE '".$srch."%' OR email LIKE '".$srch."%' ORDER BY `id` DESC";
// }else{$query = "SELECT * FROM `client`";} //uncomment this line to allow showing all clients without a search and edit line 69
sqlconnect();
$result = mysql_query($query) or die(mysql_error());
$num = mysql_num_rows($result);
if ($num >= 1) {
while ($temp = mysql_fetch_assoc($result)) {
$newvar[] = $temp;
}
foreach ($newvar as $var) {
echo"
';
echo "
";
if(strlen($var[phone1]) < 2){echo"";}else{echo $var[phone1]." -P
\n";}
if(strlen($var[phone2]) < 2){echo"";}else{echo $var[phone2]." -S
\n";}
if(strlen($var[fax]) < 2){echo"";}else{echo $var[fax]." -F
\n";}
echo"
Account # ".$var[acctcode]."-".$var[accountnbr]."
Acct. Bal.$".number_format($var['balance'],2,'.', ',')."
\n
";}
} else {echo"
No Customer Found!
";}
}else{} // <--comment out this line to allow showing all clients without a search and edit line 26
echo '
';
footer(); ?>