|
HELP
Special Pricing Accounts - Administration Authorized
|
| Name
| Company
| Status
| Edit
|
Error retrieving data from data base.
Error: ".mysql_error()." | ");
}else{
$count = mysql_num_rows($listem);
if($count < 1 or $count == ""){
echo("| No Accounts. |
");
}else{
while ($row = mysql_fetch_array($listem)) {
$ID = $row['ID'];
$name = $row['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];
}elseif($result == 4){
$Name1 = $namecut[0].' '.$namecut[1];
$Name1a = $namecut[2];
$Name2 = $namecut[3];
}else{
$Name1 = 'One';
$Name1a = 'Name';
$Name2 = $namecut[0];
}
$bizname = $row['biz_name'];
$status = $row['status'];
if($status == 'wholesale'){
$called = 'special';
}else{
$called = $status;
}
$BID[] = $ID;
$BNAME1[] = $Name1;
$BNAME1a[] = $Name1a;
$BNAME2[] = $Name2;
$BBIZ[] = $bizname;
$BSTAT[] = $status;
$CSTAT[] = $called;
}
natcasesort($BNAME2);
foreach ($BNAME2 as $key => $val) {
echo("| $BNAME1[$key] $BNAME1a[$key] $val | $BBIZ[$key] | $CSTAT[$key] | " .
" Edit " .
" DEL |
");
}
}
}
?>
| ooo |
| Special Pricing Accounts - Web Authorized
|
| Name
| Status
| Edit
|
Error retrieving data from data base.
Error: ". mysql_error()." | ");
}else{
$count = mysql_num_rows($listem2);
if($count < 1 or $count == ""){
echo("| No Web Authorized Accounts. |
");
}else{
while ($row = mysql_fetch_array($listem2)) {
$ID = $row['ID'];
$name = $row['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];
}elseif($result == 4){
$Name1 = $namecut[0].' '.$namecut[1];
$Name1a = $namecut[2];
$Name2 = $namecut[3];
}else{
$Name1 = 'One';
$Name1a = 'Name';
$Name2 = $namecut[0];
}
$BID2[] = $ID;
$BNAME12[] = $Name1;
$BNAME1a2[] = $Name1a;
$BNAME22[] = $Name2;
}
natcasesort($BNAME22);
foreach ($BNAME22 as $key => $val) {
echo("| $BNAME12[$key] $BNAME1a2[$key] $val | Home-Owner | " .
" Upgrade " .
" Delete |
");
}
}
}
?>
| ooo |
