|
HELP
Search Special Pricing Accounts Results
|
Error Searching the Data Base!
" .
"Error: " . mysql_error() . " | ");
}else{
$count = mysql_num_rows($search);
if($count < 1 or $count == ""){
echo("| No Results Found |
");
}else{
while ($result = mysql_fetch_array($search)) {
$id = $result['ID'];
$name = $result['name'];
$namecut = explode(" ", $name);
$result = count($namecut);
if($result == 2){
$Name1 = $namecut[0];
$Name1a = " ";
$Name2 = $namecut[1];
}elseif($result == 3){
$Name1 = $namecut[0];
$Name1a = $namecut[1];
$Name2 = $namecut[2];
}else{
$Name1 = 'One';
$Name1a = 'Name';
$Name2 = $namecut[0];
}
$biz_name = $result['biz_name'];
$zip = $result['zip'];
$phone = $result['phone'];
$email = $result['email'];
$status = $result['status'];
if($status == 'wholesale'){
$status = 'special';
}
$BID[] = $id;
$BNAME1[] = $Name1;
$BNAME1a[] = $Name1a;
$BNAME2[] = $Name2;
$BBIZ[] = $bizname;
$BZIP[] = $zip;
$BPHONE[] = $phone;
$BMAIL[] = $email;
$BSTAT[] = $status;
}
natcasesort($BNAME2);
foreach ($BNAME2 as $key => $val) {
echo("| $BNAME1[$key] $BNAME1a[$key] $val | " .
"$BBIZ[$key] | $BSTAT[$key] | $BPHONE[$key] | $BMAIL[$key] | " .
" Edit " .
" DEL |
");
}
}
}
?>
|
Search Again
|
