Eco-$mart Contacts

<<<<Restricted Area>>>>" . "
Problem with your username. Please Log In again.

Error: No Contact Data Selected. Please go back and select Contact Data to display."); exit(); } $info_csv = implode(",", $info); $info_count = count($info); if($repusrn == "All"){ $tisit = ""; }else{ $tisit = "AND usrn = '".$repusrn."'"; } $mess = "No Message yet."; ?>

Eco-$mart Contact List

Report Generated by:

"); foreach($info as $value){ if($value == "first_Name"){ $nite = "First Name"; }elseif($value == "Name"){ $nite = "Last Name"; }elseif($value == "email"){ $nite = "Email"; }else{ $nite = $value; } echo("$nite ¦ "); } echo(""); }elseif($formtype == "csv" AND $repusrn != "All"){ echo("Commma Separated Values for $repusrn in $info_count Columns:
"); foreach($info as $value){ if($value == "first_Name"){ $nite = "First Name"; }elseif($value == "Name"){ $nite = "Last Name"; }elseif($value == "email"){ $nite = "Email"; }else{ $nite = $value; } echo("$nite ¦ "); } echo(""); }elseif($formtype == "print" AND $repusrn != "All"){ echo("Contact List for $repusrn in $info_count Columns:
"); foreach($info as $value){ if($value == "first_Name"){ $nite = "First Name"; }elseif($value == "Name"){ $nite = "Last Name"; }elseif($value == "email"){ $nite = "Email"; echo(""); }else{ $nite = $value; } echo("$nite ¦ "); } }else{ echo("Contact List for All Contacts in $info_count Columns:
"); foreach($info as $value){ if($value == "first_Name"){ $nite = "First Name"; }elseif($value == "Name"){ $nite = "Last Name"; }elseif($value == "email"){ $nite = "Email"; }else{ $nite = $value; } echo("$nite ¦ "); } echo(""); } ?>

"); foreach($biztype as $value){ echo("$value"); $new = @mysql_query("SELECT $info_csv FROM con_main WHERE biztype='$value' $tisit ORDER BY Name"); if(!$new){ echo("

Problem retrieving List.
Error: ". mysql_error()."

"); } $num_rows = mysql_num_rows($new); if($num_rows < 1){ echo("No Contacts for this Business Type."); }else{ echo(""); foreach($info as $value){ if($value == "first_Name"){ $inside = "First Name"; }elseif($value == "Name"){ $inside = "Last Name"; }elseif($value == "State"){ $inside = "ST"; }else{ $inside = $value; } echo("$inside"); }//4ea }//else echo(""); $c = 1; while($rows = mysql_fetch_array($new)){ $ck = $c / 2; if(is_int($ck)){ $cell = "style='border:solid silver 1;background-color:white;'"; }else{ $cell = "style='border:solid silver 1;background-color:#ffffc0;'"; } $go = "go"; $aa = $rows[0]; $bb = $rows[1]; $cc = $rows[2]; $dd = $rows[3]; $ee = $rows[4]; $ff = $rows[5]; $gg = $rows[6]; $hh = $rows[7]; $ii = $rows[8]; if(ereg("Test", $aa) or ereg("test", $aa)){ $go = "no"; } if(ereg("Test", $bb) or ereg("test", $bb)){ $go = "no"; } if(in_array($aa, $aack) AND in_array($bb, $bbck)){ $go = "no"; } if($go == "go"){ $aack[] = $aa; $bbck[] = $bb; echo(""); if($aa == "n/a" or $aa == "NA" or $aa == "N/A" or $aa == "none" or $aa == "No Email" or $aa == "lklk" or $aa == "?"){ $ay = ""; }else{ $az = stripslashes($aa); $ay = str_replace ( ',', " ", $az); } echo("$ay"); if($info_count > 1){ if($bb == "n/a" or $bb == "NA" or $bb == "N/A" or $bb == "none" or $bb == "No Email" or $bb == "lklk" or $bb == "?"){ $by = " "; }else{ $bz = stripslashes($bb); $by = str_replace ( ',', " ", $bz); } echo("$by"); } if($info_count > 2){ if($cc == "n/a" or $cc == "NA" or $cc == "N/A" or $cc == "none" or $cc == "No Email" or $cc == "lklk" or $cc == "?"){ $cy = " "; }else{ $cz = stripslashes($cc); $cy = str_replace ( ',', " ", $cz); } echo("$cy"); } if($info_count > 3){ if($dd == "n/a" or $dd == "NA" or $dd == "N/A" or $dd == "none" or $dd == "No Email" or $dd == "lklk" or $dd == "?"){ $dy = " "; }else{ $dz = stripslashes($dd); $dy = str_replace ( ',', " ", $dz); } echo("$dy"); } if($info_count > 4){ if($ee == "n/a" or $ee == "NA" or $ee == "N/A" or $ee == "none" or $ee == "No Email" or $ee == "lklk" or $ee == "?"){ $ey = " "; }else{ $ez = stripslashes($ee); $ey = str_replace ( ',', " ", $ez); } echo("$ey"); } if($info_count > 5){ if($ff == "n/a" or $ff == "NA" or $ff == "N/A" or $ff == "none" or $ff == "No Email" or $ff == "lklk" or $ff == "?"){ $fy = " "; }else{ $fz = stripslashes($ff); $fy = str_replace ( ',', " ", $fz); } echo("$fy"); } if($info_count > 6){ if($gg == "n/a" or $gg == "NA" or $gg == "N/A" or $gg == "none" or $gg == "No Email" or $gg == "lklk" or $gg == "?"){ $gy = " "; }else{ $gz = stripslashes($gg); $gy = str_replace ( ',', " ", $gz); } echo("$gy"); } if($info_count > 7){ if($hh == "n/a" or $hh == "NA" or $hh == "N/A" or $hh == "none" or $hh == "No Email" or $hh == "lklk" or $hh == "?"){ $hy = " "; }else{ $hz = stripslashes($hh); $hy = str_replace ( ',', " ", $hz); } echo("$hy"); } if($info_count > 8){ if($ii == "n/a" or $ii == "NA" or $ii == "N/A" or $ii == "none" or $ii == "No Email" or $ii == "lklk" or $ii == "?"){ $iy = " "; }else{ $iz = stripslashes($ii); $iy = str_replace ( ',', " ", $iz); } echo("$iy"); } echo(""); $c = $c + 1; }//while }//goisgo }//4ea echo(""); }//ifformtypeisprint elseif($formtype == "csv"){ $scrip = "\"javascript:selectAll('test.select1');\""; echo("" . "" . "

"); if($repusrn == "All"){ echo("Business Type: "); foreach($biztype as $value){ echo("$value ¦ "); } }else{ echo("Business Type: "); foreach($biztype as $value){ echo("$value ¦ "); } } echo("

" . "Instructions:" . "
1, Select All text in the Text Area below and Copy." . "
2. Paste the script into a new file in a Plain Text editor (eg.,Note Pad or Simple Text)." . "
3. Save As "some_file_name.csv"." . "
You will then be able to open the file in Excel or other spreadsheet and import into an address book or data base as a Comma Separated Values file.

" . "

");
foreach($biztype as $value){
$result = mysql_query("SELECT $info_csv FROM con_main WHERE biztype='$value' $tisit ORDER BY Name");
if (!$result) {
echo("Could not get CSV for $value <br />".mysql_error()."<br />");
}else{
while($rows = mysql_fetch_array($result)) {
$aa[] = $rows[0];
$bb[] = $rows[1];
$cc[] = $rows[2];
$dd[] = $rows[3];
$ee[] = $rows[4];
$ff[] = $rows[5];
$gg[] = $rows[6];
$hh[] = $rows[7];
$ii[] = $rows[8];
}//while
$aa_count = count($aa);
$i = 0;
while($i < $aa_count){
$go = "go";
if(ereg("Test", $aa[$i]) or ereg("test", $aa[$i])){
$go = "no";
}
if(ereg("Test", $bb[$i]) or ereg("test", $bb[$i])){
$go = "no";
}
if(in_array($aa[$i],$aack) AND in_array($bb[$i],$bbck)){
$go = "no";
}
if($go == "go"){
$aack[] = $aa[$i];
$bbck[] = $bb[$i];
if($aa[$i] == "n/a" or $aa[$i] == "NA" or $aa[$i] == "N/A" or $aa[$i] == "none" or $aa[$i] == "No Email" or $aa[$i] == "lklk" or $aa[$i] == "?"){
$ay = " ";
}else{
$az = stripslashes($aa[$i]);
$ay = str_replace ( ',', " ", $az);
}
echo("$ay");
if($info_count > 1){
if($bb[$i] == "n/a" or $bb[$i] == "NA" or $bb[$i] == "N/A" or $bb[$i] == "none" or $bb[$i] == "No Email" or $bb[$i] == "lklk" or $bb[$i] == "?"){
$by = " ";
}else{
$bz = stripslashes($bb[$i]);
$by = str_replace ( ',', " ", $bz);
}
echo(",$by");
}
if($info_count > 2){
if($cc[$i] == "n/a" or $cc[$i] == "NA" or $cc[$i] == "N/A" or $cc[$i] == "none" or $cc[$i] == "No Email" or $cc[$i] == "lklk" or $cc[$i] == "?"){
$cy = " ";
}else{
$cy = str_replace ( ',', " ", $cc[$i]);
}
echo(",$cy");
}
if($info_count > 3){
if($dd[$i] == "n/a" or $dd[$i] == "NA" or $dd[$i] == "N/A" or $dd[$i] == "none" or $dd[$i] == "No Email" or $dd[$i] == "lklk" or $dd[$i] == "?"){
$dy = " ";
}else{
$dy = str_replace ( ',', " ", $dd[$i]);
}
echo(",$dy");
}
if($info_count > 4){
if($ee[$i] == "n/a" or $ee[$i] == "NA" or $ee[$i] == "N/A" or $ee[$i] == "none" or $ee[$i] == "No Email" or $ee[$i] == "lklk" or $ee[$i] == "?"){
$ey = " ";
}else{
$ey = str_replace ( ',', " ", $ee[$i]);
}
echo(",$ey");
}
if($info_count > 5){
if($ff[$i] == "n/a" or $ff[$i] == "NA" or $ff[$i] == "N/A" or $ff[$i] == "none" or $ff[$i] == "No Email" or $ff[$i] == "lklk" or $ff[$i] == "?"){
$fy = " ";
}else{
$fy = str_replace ( ',', " ", $ff[$i]);
}
echo(",$fy");
}
if($info_count > 6){
if($gg[$i] == "n/a" or $gg[$i] == "NA" or $gg[$i] == "N/A" or $gg[$i] == "none" or $gg[$i] == "No Email" or $gg[$i] == "lklk" or $gg[$i] == "?"){
$gy = " ";
}else{
$gy = str_replace ( ',', " ", $gg[$i]);
}
echo(",$gy");
}
if($info_count > 7){
if($hh[$i] == "n/a" or $hh[$i] == "NA" or $hh[$i] == "N/A" or $hh[$i] == "none" or $hh[$i] == "No Email" or $hh[$i] == "lklk" or $hh[$i] == "?"){
$hy = " ";
}else{
$hy = str_replace ( ',', " ", $hh[$i]);
}
echo(",$hy");
}
if($info_count > 8){
if($ii[$i] == "n/a" or $ii[$i] == "NA" or $ii[$i] == "N/A" or $ii[$i] == "none" or $ii[$i] == "No Email" or $ii[$i] == "lklk" or $ii[$i] == "?"){
$iy = " ";
}else{
$iy = str_replace ( ',', " ", $ii[$i]);
}
echo(",$iy");
}
echo("");
}//goisgo
$i = $i+1;
}//while2
}//ifgoodresult
}//4ea
echo("

"); }else{//nocsvnoprint echo("" . "

Problems with formulation of list.
Too much information to process." . "

"); } ?>

List Created at Eco-smart.com -