sql_query($sql);
$rows = $db->num_rows();
if($rows > 0){
$x=1;
while($user = $db->fetch_array()){
?>
|
Company Name - |
| Member Name : |
|
| Street Address: |
|
| City, State, Zip: |
|
| Phone: |
|
| Fax: |
|
| Email: |
|
| Website: |
|
| Type of membership: |
|
| Services: |
""){
if($x == 1){
echo $user['AGE'];
}else{
echo ", ".$user['AGE'];
}
$x++;
}
if($user['ARB'] <> ""){
if($x == 1){
echo $user['ARB'];
}else{
echo ", ".$user['ARB'];
}
$x++;
}
if($user['CT'] <> ""){
if($x == 1){
echo $user['CT'];
}else{
echo ", ".$user['CT'];
}
$x++;
}
if($user['COM'] <> ""){
if($x == 1){
echo $user['COM'];
}else{
echo ", ".$user['COM'];
}
$x++;
}
if($user['CON'] <> ""){
if($x == 1){
echo $user['CON'];
}else{
echo ", ".$user['CON'];
}
$x++;
}
if($user['CGR'] <> ""){
if($x == 1){
echo $user['CGR'];
}else{
echo ", ".$user['CGR'];
}
$x++;
}
if($user['CF'] <> ""){
if($x == 1){
echo $user['CF'];
}else{
echo ", ".$user['CF'];
}
$x++;
}
if($user['EDU'] <> ""){
if($x == 1){
echo $user['EDU'];
}else{
echo ", ".$user['EDU'];
}
$x++;
}
if($user['EQU'] <> ""){
if($x == 1){
echo $user['EQU'];
}else{
echo ", ".$user['EQU'];
}
$x++;
}
if($user['FEN'] <> ""){
if($x == 1){
echo $user['FEN'];
}else{
echo ", ".$user['FEN'];
}
$x++;
}
if($user['FLO'] <> ""){
if($x == 1){
echo $user['FLO'];
}else{
echo ", ".$user['FLO'];
}
$x++;
}
if($user['GC'] <> ""){
if($x == 1){
echo $user['GC'];
}else{
echo ", ".$user['GC'];
}
$x++;
}
if($user['GFC'] <> ""){
if($x == 1){
echo $user['GFC'];
}else{
echo ", ".$user['GFC'];
}
$x++;
}
if($user['GR'] <> ""){
if($x == 1){
echo $user['GR'];
}else{
echo ", ".$user['GR'];
}
$x++;
}
if($user['GW'] <> ""){
if($x == 1){
echo $user['GW'];
}else{
echo ", ".$user['GW'];
}
$x++;
}
if($user['HAR'] <> ""){
if($x == 1){
echo $user['HAR'];
}else{
echo ", ".$user['HAR'];
}
$x++;
}
if($user['HS'] <> ""){
if($x == 1){
echo $user['HS'];
}else{
echo ", ".$user['HS'];
}
$x++;
}
if($user['INS'] <> ""){
if($x == 1){
echo $user['INS'];
}else{
echo ", ".$user['INS'];
}
$x++;
}
if($user['INR'] <> ""){
if($x == 1){
echo $user['INR'];
}else{
echo ", ".$user['INR'];
}
$x++;
}
if($user['IRR'] <> ""){
if($x == 1){
echo $user['IRR'];
}else{
echo ", ".$user['IRR'];
}
$x++;
}
if($user['LA'] <> ""){
if($x == 1){
echo $user['LA'];
}else{
echo ", ".$user['LA'];
}
$x++;
}
if($user['LD'] <> ""){
if($x == 1){
echo $user['LD'];
}else{
echo ", ".$user['LD'];
}
$x++;
}
if($user['LC'] <> ""){
if($x == 1){
echo $user['LC'];
}else{
echo ", ".$user['LC'];
}
$x++;
}
if($user['LG'] <> ""){
if($x == 1){
echo $user['LG'];
}else{
echo ", ".$user['LG'];
}
$x++;
}
if($user['LM'] <> ""){
if($x == 1){
echo $user['LM'];
}else{
echo ", ".$user['LM'];
}
$x++;
}
if($user['LT'] <> ""){
if($x == 1){
echo $user['LT'];
}else{
echo ", ".$user['LT'];
}
$x++;
}
if($user['MO'] <> ""){
if($x == 1){
echo $user['MO'];
}else{
echo ", ".$user['MO'];
}
$x++;
}
if($user['MR'] <> ""){
if($x == 1){
echo $user['MR'];
}else{
echo ", ".$user['MR'];
}
$x++;
}
if($user['MAS'] <> ""){
if($x == 1){
echo $user['MAS'];
}else{
echo ", ".$user['MAS'];
}
$x++;
}
if($user['MUN'] <> ""){
if($x == 1){
echo $user['MUN'];
}else{
echo ", ".$user['MUN'];
}
$x++;
}
if($user['NR'] <> ""){
if($x == 1){
echo $user['NR'];
}else{
echo ", ".$user['NR'];
}
$x++;
}
if($user['NW'] <> ""){
if($x == 1){
echo $user['NW'];
}else{
echo ", ".$user['NW'];
}
$x++;
}
if($user['O'] <> ""){
if($x == 1){
echo $user['O'];
}else{
echo ", ".$user['O'];
}
$x++;
}
if($user['PAV'] <> ""){
if($x == 1){
echo $user['PAV'];
}else{
echo ", ".$user['PAV'];
}
$x++;
}
if($user['PER'] <> ""){
if($x == 1){
echo $user['PER'];
}else{
echo ", ".$user['PER'];
}
$x++;
}
if($user['PRO'] <> ""){
if($x == 1){
echo $user['PRO'];
}else{
echo ", ".$user['PRO'];
}
$x++;
}
if($user['REW'] <> ""){
if($x == 1){
echo $user['REW'];
}else{
echo ", ".$user['REW'];
}
$x++;
}
if($user['SG'] <> ""){
if($x == 1){
echo $user['SG'];
}else{
echo ", ".$user['SG'];
}
$x++;
}
if($user['STO'] <> ""){
if($x == 1){
echo $user['STO'];
}else{
echo ", ".$user['STO'];
}
$x++;
}
if($user['SU'] <> ""){
if($x == 1){
echo $user['SU'];
}else{
echo ", ".$user['SU'];
}
$x++;
}
if($user['WG'] <> ""){
if($x == 1){
echo $user['WG'];
}else{
echo ", ".$user['WG'];
}
$x++;
}
if($user['WM'] <> ""){
if($x == 1){
echo $user['WM'];
}else{
echo ", ".$user['WM'];
}
$x++;
}
?> |
";
}
if($user['cert_landscape'] == "Yes"){
echo " ";
}
?>
|
|
close();
?>
|
