|
HELP
Requests for Special Pricing
|
Error retrieving New Registrations from Data Base!
" .
"Error:" . mysql_error() . " | ");
}else{
$count = mysql_num_rows($new);
if($count < 1 or $count == ""){
echo("| No New Registrations. |
");
}else{
while ($newreg = mysql_fetch_array($new)){
$ID = $newreg['ID'];
$name = $newreg['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 = $newreg['biz_name'];
$address_1 = $newreg['address_1'];
$address_2 = $newreg['address_2'];
$city = $newreg['city'];
$state = $newreg['state'];
$zip = $newreg['zip'];
$country = $newreg['country'];
$phone = $newreg['phone'];
$email = $newreg['email'];
$customer_type = $newreg['customer_type'];
$specify = $newreg['specify'];
$username = $newreg['username'];
$password = $newreg['password'];
$BID[] = $ID;
$BNAME1[] = $Name1;
$BNAME1a[] = $Name1a;
$BNAME2[] = $Name2;
$BBIZ[] = $biz_name;
$ADD1[] = $address_1;
$ADD2[] = $address_2;
$CITY[] = $city;
$STATE[] = $state;
$ZIP[] = $zip;
$COUNTRY[] = $country;
$PHONE[] = $phone;
$EMAIL[] = $email;
$CUST[] = $customer_type;
$SPEC[] = $specify;
}
natcasesort($BNAME2);
foreach ($BNAME2 as $key => $val) {
echo("| Authorize " .
" Deny | ".
"$BNAME1[$key] $BNAME1a[$key] $val | $BBIZ[$key]" .
" |
" .
" | $ADD1[$key] $ADD2[$key]
$CITY[$key], $STATE[$key] $ZIP[$key] | " .
"$PHONE[$key]
$EMAIL[$key] |
");
}
}
}
?>
©2007 - Data Base Interface - Custom Built at:
|
