<? 
session_start();

if ($_SESSION["FM_status"] != "login") {
	header("Location: login.asp");
} 
?>
<? 
header("Expires: ".gmdate("D, d M Y H:i:s",time()+(0*60))." GMT");
header("pragma: no-cache");
header("cache-control: private");
header("Cache-Control: no-cache");
?>
<?
	require "db.asp";
	//require "aspmkrfn.asp";
?>
<?
	$displayRecs = 20;
	$recRange = 10;
?>
<?
	$dbwhere = "";
	$masterdetailwhere = "";
	$searchwhere = "";
	$a_search = "";
	$b_search = "";
	$whereClause = "";
?>
<? 
// Get search criteria for basic search
$pSearch=$_GET["psearch"];
$pSearchType=$_GET["psearchType"];
if ($pSearch != "") {
  $pSearch=str_replace("'","''",$pSearch);
  $pSearch=str_replace("[","[[]",$pSearch);
  if ($pSearchType != "") {
    while (_instr(0,$pSearch,"  ",0) > 0) {
      $pSearch=str_replace("  "," ",$pSearch);
    }
    $arpSearch=explode(" ",trim($pSearch));
    foreach ($arpSearch as $kw) {
      $b_search.="(";
      $b_search.="Nombre LIKE '%".trim($kw)."%' OR ";
      $b_search.="Apellido LIKE '%".trim($kw)."%' OR ";
      $b_search.="Empresa LIKE '%".trim($kw)."%' OR ";
      $b_search.="Cargo LIKE '%".trim($kw)."%' OR ";
      $b_search.="Profesion LIKE '%".trim($kw)."%' OR ";
      $b_search.="Domicilio LIKE '%".trim($kw)."%' OR ";
      $b_search.="CPostal LIKE '%".trim($kw)."%' OR ";
      $b_search.="Ciudad LIKE '%".trim($kw)."%' OR ";
      $b_search.="Provincia LIKE '%".trim($kw)."%' OR ";
      $b_search.="Pais LIKE '%".trim($kw)."%' OR ";
      $b_search.="Telefono LIKE '%".trim($kw)."%' OR ";
      $b_search.="Email LIKE '%".trim($kw)."%' OR ";
      $b_search.="actividad LIKE '%".trim($kw)."%' OR ";
      $b_search.="main LIKE '%".trim($kw)."%' OR ";
      $b_search.="empleados LIKE '%".trim($kw)."%' OR ";
      $b_search.="implicado LIKE '%".trim($kw)."%' OR ";
      if (substr($b_search,-4) == " OR ") {
        $b_search=substr($b_search,0,strlen($b_search)-4);
      }
      $b_search.=") ".$pSearchType." ";
    }
  }
  else {
    $b_search.="Nombre LIKE '%".$pSearch."%' OR ";
    $b_search.="Apellido LIKE '%".$pSearch."%' OR ";
    $b_search.="Empresa LIKE '%".$pSearch."%' OR ";
    $b_search.="Cargo LIKE '%".$pSearch."%' OR ";
    $b_search.="Profesion LIKE '%".$pSearch."%' OR ";
    $b_search.="Domicilio LIKE '%".$pSearch."%' OR ";
    $b_search.="CPostal LIKE '%".$pSearch."%' OR ";
    $b_search.="Ciudad LIKE '%".$pSearch."%' OR ";
    $b_search.="Provincia LIKE '%".$pSearch."%' OR ";
    $b_search.="Pais LIKE '%".$pSearch."%' OR ";
    $b_search.="Telefono LIKE '%".$pSearch."%' OR ";
    $b_search.="Email LIKE '%".$pSearch."%' OR ";
    $b_search.="actividad LIKE '%".$pSearch."%' OR ";
    $b_search.="main LIKE '%".$pSearch."%' OR ";
    $b_search.="empleados LIKE '%".$pSearch."%' OR ";
    $b_search.="implicado LIKE '%".$pSearch."%' OR ";
  }
}
if (substr($b_search,-4) == " OR ") {
  $b_search=substr($b_search,0,strlen($b_search)-4);
}
if (substr($b_search,-5) == " AND ") {
  $b_search=substr($b_search,0,strlen($b_search)-5);
}

?>
<?
//Build search criteria
if ($a_search != ""){
	$searchwhere = $a_search; // Advanced search
} else if ($b_search != ""){
	$searchwhere = $b_search; // Basic search
}

//Save search criteria
if ($searchwhere != ""){
	$_SESSION["Suscriptores_searchwhere"] = $searchwhere;

	// Reset start record counter (new search)
	$startRec = 1;
	$_SESSION["Suscriptores_REC"] = $startRec;
} else {
	$searchwhere = $_SESSION["Suscriptores_searchwhere"];
}
?>
<? 
// Get clear search cmd
if ((int)isset($_GET["cmd"]) > 0) {
  $cmd=$_GET["cmd"];
  if (strtoupper($cmd) == "RESET") {
    // Reset search criteria
    $searchwhere="";
	$_SESSION["Suscriptores_searchwhere"] = $searchwhere;
  }
  elseif (strtoupper($cmd) == "RESETALL") {
    // Reset search criteria
    $searchwhere="";
	$_SESSION["Suscriptores_searchwhere"] = $searchwhere;
  }
  // Reset start record counter (reset command)
  $startRec=1;
	$_SESSION["Suscriptores_REC"] = $startRec;
}

// Build dbwhere
if ($masterdetailwhere != "") {
  $dbwhere.="(".$masterdetailwhere.") AND ";
}
if ($searchwhere != "") {
  $dbwhere.="(".$searchwhere.") AND ";
}
if (strlen($dbwhere) > 5) {
  $dbwhere=substr($dbwhere,0,strlen($dbwhere)-5);
  // Trim rightmost AND
}

// Load Default Order
$DefaultOrder="";
$DefaultOrderType="";

// No Default Filter
$DefaultFilter="";

// Check for an Order parameter
$OrderBy="";
if ((int)isset($_GET["order"]) > 0) {
  $OrderBy=$_GET["order"];
  // Check if an ASC/DESC toggle is required
  if ($_SESSION["Suscriptores_OB"] == $OrderBy) {
    if ($_SESSION["Suscriptores_OT"] == "ASC") {
		$_SESSION["Suscriptores_OT"] = "DESC";
    }
    else {
		$_SESSION["Suscriptores_OT"] = "ASC";
    }
  }
  else {
	$_SESSION["Suscriptores_OT"] = "ASC";
  }
	$_SESSION["Suscriptores_OB"] = $OrderBy;
	$_SESSION["Suscriptores_REC"] = 1;
}
else {
  $OrderBy = $_SESSION["Suscriptores_OB"];
  if ($OrderBy == "") {
    $OrderBy=$DefaultOrder;
	$_SESSION["Suscriptores_OB"] = $OrderBy;
	$_SESSION["Suscriptores_OT"] = $DefaultOrderType;
  }
}

// Build SQL
$strsql="SELECT * FROM Suscriptores";
if ($DefaultFilter != "") {
  $whereClause.="(".$DefaultFilter.") AND ";
}
if ($dbwhere != "") {
  $whereClause.="(".$dbwhere.") AND ";
}
if (substr($whereClause,-5) == " AND ") {
  $whereClause=substr($whereClause,0,strlen($whereClause)-5);
}
if ($whereClause != "") {
  $strsql.=" WHERE ".$whereClause;
}
if ($OrderBy != "") {
  $strsql.=" ORDER BY ".$OrderBy." ". $_SESSION["Suscriptores_OT"]; 
}

//echo $strsql;
$result = $conn->query($strsql);
$totalRecs=$result->num_rows;

// Check for a START parameter
if ((int)isset($_GET["start"]) > 0) {
	$startRec=$_GET["start"];
	$_SESSION["Suscriptores_REC"] = $startRec;
}
elseif ((int)isset($_GET["pageno"]) > 0) {
  $pageno=$_GET["pageno"];
  if (is_numeric($pageno)) {
    $startRec=($pageno-1) * $displayRecs + 1;
    if ($startRec <= 0) {
      $startRec=1;
    }
    elseif ($startRec >= (($totalRecs-1) / $displayRecs) * $displayRecs + 1) {
      $startRec=(($totalRecs-1) / $displayRecs) * $displayRecs + 1;
    }
	$_SESSION["Suscriptores_REC"] = $startRec;
  }
  else {
    $startRec=$_SESSION["Suscriptores_REC"]; 
    if (!is_numeric($startRec) || $startRec == "") {
      $startRec=1;
      // Reset start record counter
		$_SESSION["Suscriptores_REC"] = $startRec;
    }
  }
}
else {
  $startRec=$_SESSION["Suscriptores_REC"]; // WARNING: unable to convert Session
  if (!is_numeric($startRec) || $startRec == "") {
    $startRec=1;
    //Reset start record counter
	$_SESSION["Suscriptores_REC"] = $startRec;
  }
}

// Helper Functions

function _instr($start,$str1,$str2,$mode) {
if ($mode) { $str1=strtolower($str1); $str2=strtolower($str2); }
$retval=strpos($str1,$str2,$start);
return ($retval===false) ? 0 : $retval+1;
}

require "header.asp";
?>
<p><span class="titular">TABLA: Suscriptores</span></p>
<form action="FMSuscriptoreslist.asp">
<table border="0" cellspacing="0" cellpadding="4">
	<tr>
		<td><span class="aspmaker">Quick Search (*)</span></td>		
		<td><span class="aspmaker">
			<input type="text" name="psearch" size="20">
			<input type="Submit" name="Submit" value="buscar">
		&nbsp;&nbsp;<a href="FMSuscriptoreslist.asp?cmd=reset">mostrar todol</a>
		</span></td>
	</tr>
	<tr><td>&nbsp;</td><td><span class="aspmaker"><input type="radio" name="psearchtype" value="" checked>frase
        exacta&nbsp;&nbsp;<input type="radio" name="psearchtype" value="AND">todas
        las palabras&nbsp;&nbsp;<input type="radio" name="psearchtype" value="OR">ninguna
        palabra</span></td></tr>	
</table>
</form>
<form method="post">
        <table border="0" cellspacing="1" cellpadding="4">
	      <tr>
		    <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("Id") ?>" style="color: #FFFFFF;">Id&nbsp;
              <? if ($OrderBy == "Id") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("Nombre") ?>" style="color: #FFFFFF;">Nombre&nbsp;(*)
              <? if ($OrderBy == "Nombre") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("Apellido") ?>" style="color: #FFFFFF;">Apellido&nbsp;(*)
              <? if ($OrderBy == "Apellido") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("Empresa") ?>" style="color: #FFFFFF;">Empresa&nbsp;(*)
              <? if ($OrderBy == "Empresa") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("Cargo") ?>" style="color: #FFFFFF;">Cargo&nbsp;(*)
              <? if ($OrderBy == "Cargo") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("Profesion") ?>" style="color: #FFFFFF;">Profesion&nbsp;(*)
              <? if ($OrderBy == "Profesion") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("Domicilio") ?>" style="color: #FFFFFF;">Domicilio&nbsp;(*)
              <? if ($OrderBy == "Domicilio") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("CPostal") ?>" style="color: #FFFFFF;">CPostal&nbsp;(*)
              <? if ($OrderBy == "CPostal") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("Ciudad") ?>" style="color: #FFFFFF;">Ciudad&nbsp;(*)
              <? if ($OrderBy == "Ciudad") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("Provincia") ?>" style="color: #FFFFFF;">Provincia&nbsp;(*)
              <? if ($OrderBy == "Provincia") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("Pais") ?>" style="color: #FFFFFF;">Pais&nbsp;(*)
              <? if ($OrderBy == "Pais") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("Telefono") ?>" style="color: #FFFFFF;">Telefono&nbsp;(*)
              <? if ($OrderBy == "Telefono") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("Email") ?>" style="color: #FFFFFF;">Email&nbsp;(*)
              <? if ($OrderBy == "Email") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("Fecha") ?>" style="color: #FFFFFF;">Fecha&nbsp;
              <? if ($OrderBy == "Fecha") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("Hora") ?>" style="color: #FFFFFF;">Hora&nbsp;
              <? if ($OrderBy == "Hora") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("actividad") ?>" style="color: #FFFFFF;">actividad&nbsp;(*)
              <? if ($OrderBy == "actividad") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("main") ?>" style="color: #FFFFFF;">main&nbsp;(*)
              <? if ($OrderBy == "main") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("empleados") ?>" style="color: #FFFFFF;">empleados&nbsp;(*)
              <? if ($OrderBy == "empleados") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC"><span class="aspmaker" style="color: #FFFFFF;">
<a href="FMSuscriptoreslist.asp?order=<?=urlencode("implicado") ?>" style="color: #FFFFFF;">implicado&nbsp;(*)
              <? if ($OrderBy == "implicado") { ?>
              <span class="ewTableOrderIndicator">
              <? if ($_SESSION["Suscriptores_OT"] == "ASC") { ?>
              5
              <? } elseif ($_SESSION["Suscriptores_OT"] == "DESC") { ?>
              6
              <? } ?>
              </span>
              <? } ?>
              </a>
		</span></td>
            <td bgcolor="#0099CC">&nbsp;</td>
            <td bgcolor="#0099CC">&nbsp;</td>
            <td bgcolor="#0099CC">&nbsp;</td>
            <td bgcolor="#0099CC">&nbsp;</td>
          </tr>
<?
	// Avoid starting record > total records
	if (intval($startRec) > intval($totalRecs)) {
	  $startRec=$totalRecs;
	}
	// Set the last record to display
	$stopRec=$startRec + $displayRecs-1;
	// Move to first record directly for performance reason
	//$recCount=$startRec-1;
	$recCount=0;
	
	$tot_Id=0;
	// Initialise total to zero for aggregation
	$cnt_Id=0;
	// Initialise count to zero for aggregation
	$recActual=0;
	
	while(($row = $result->fetch_assoc())) {
	
		$recCount++;
		if (intval($recCount) >= intval($startRec) && ($recCount <= $stopRec)) {
		
			$recActual++;
			// Set row color
			$bgcolor="#FFFFFF";
			// Display alternate color for rows
			if ($recCount % 2 != 0) {
			  $bgcolor="#F5F5F5";
			}
			// Load Key for record
			$key=$row["Id"];
			$x_Id=$row["Id"];
			$tot_Id+=$x_Id;
			// Accumulate Total
			$cnt_Id++;
			// Increment no. of records
			$x_Nombre=$row["Nombre"];
			$x_Apellido=$row["Apellido"];
			$x_Empresa=$row["Empresa"];
			$x_Cargo=$row["Cargo"];
			$x_Profesion=$row["Profesion"];
			$x_Domicilio=$row["Domicilio"];
			$x_CPostal=$row["CPostal"];
			$x_Ciudad=$row["Ciudad"];
			$x_Provincia=$row["Provincia"];
			$x_Pais=$row["Pais"];
			$x_Telefono=$row["Telefono"];
			$x_Email=$row["Email"];
			$x_Fecha=$row["Fecha"];
			$x_Hora=$row["Hora"];
			$x_actividad=$row["actividad"];
			$x_main=$row["main"];
			$x_empleados=$row["empleados"];
			$x_implicado=$row["implicado"];
?>
          
	      <tr>
		    <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_Id?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_Nombre?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_Apellido?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_Empresa?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_Cargo?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_Profesion?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_Domicilio?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_CPostal?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_Ciudad?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_Provincia?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_Pais?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_Telefono?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_Email?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_Fecha?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
             <?if (strlen($x_Hora) > 10){ echo substr($x_Hora, 10); } else {  echo $x_Hora; } ?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_actividad?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_main?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_empleados?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><span class="aspmaker">
              <?=$x_implicado?>
              </span>&nbsp;</td>
            <td bgcolor="<?=$bgcolor ?>"><b><span class="aspmaker"><a href="<? if ($row["Id"]) { echo "FMSuscriptoresview.asp?key=" . urlencode($row["Id"]); } else { echo "javascript:alert('Invalid Record! Key is null');"; } ?>">View</a></span></b></td>
            <td bgcolor="<?=$bgcolor ?>"><b><span class="aspmaker"><a href="<? if ($row["Id"]) { echo "FMSuscriptoresedit.asp?key=" . urlencode($row["Id"]); } else { echo "javascript:alert('Invalid Record! Key is null');"; } ?>">Edit</a></span></b></td>
            <td bgcolor="<?=$bgcolor ?>"><b><span class="aspmaker"><a href="<? if ($row["Id"]) { echo "FMSuscriptoresadd.asp?key=" . urlencode($row["Id"]); } else { echo "javascript:alert('Invalid Record! Key is null');"; } ?>">Copy</a></span></b></td>
            <td bgcolor="<?=$bgcolor ?>"><b><span class="aspmaker"><a href="<? if ($row["Id"]) { echo "FMSuscriptoresdelete.asp?key=" . urlencode($row["Id"]); } else { echo "javascript:alert('Invalid Record! Key is null');"; } ?>">Delete</a></span></b></td>
          </tr>
<?
		}
	}
	
	$x_Id = $cnt_Id;
?>
	      <tr valign="top">
		    <td>
        <b><span class="aspmaker">Total: </span>
        &nbsp;</b></td>
            <td><b><span class="aspmaker">
              <?=$x_Id?>
              </span>
		</b></td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;
		</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
          </tr>
        </table>
</form>
<?
// Close recordset and connection
$conn->close();
?>
<table border="0" cellspacing="0" cellpadding="10"><tr><td>
<?
 if ($totalRecs > 0) {
      $rsEof=($totalRecs < ($startRec + $displayRecs));
      $PrevStart=$startRec-$displayRecs;
      if ($PrevStart < 1) {
        $PrevStart=1;
      }
      $NextStart=$startRec + $displayRecs;
      if ($NextStart > $totalRecs) {
        $NextStart=$startRec;
      }
      $LastStart=(($totalRecs-1) / $displayRecs) * $displayRecs + 1;
    
?>
<form>	
	<table border="0" cellspacing="0" cellpadding="0"><tr><td><span class="aspmaker">P�gina</span>&nbsp;</td>
<!--first page button-->
	<? if (intval($startRec) == 1) { ?>
	<td><img src="images/firstdisab.gif" alt="First" width="20" height="15" border="0"></td>
	<? } else { ?>
	<td><a href="FMSuscriptoreslist.asp?start=1"><img src="images/first.gif" alt="First" width="20" height="15" border="0"></a></td>
	<? } ?>
<!--previous page button-->
	<? if (intval($PrevStart) == intval($startRec)) { ?>
	<td><img src="images/prevdisab.gif" alt="Previous" width="20" height="15" border="0"></td>
	<? } else { ?>
	<td><a href="FMSuscriptoreslist.asp?start=<?=$PrevStart?>"><img src="images/prev.gif" alt="Previous" width="20" height="15" border="0"></a></td>
	<? } ?>
<!--current page number-->
	<td><input type="text" name="pageno" value="<?=intval(($startRec-1)/$displayRecs+1)?>" size="4"></td>
<!--next page button-->
	<? if (intval($NextStart) == intval($startRec)) { ?>
	<td><img src="images/nextdisab.gif" alt="Next" width="20" height="15" border="0"></td>
	<? } else { ?>
	<td><a href="FMSuscriptoreslist.asp?start=<?=$NextStart?>"><img src="images/next.gif" alt="Next" width="20" height="15" border="0"></a></td>
	<? } ?>
<!--last page button-->
	<? if (intval($LastStart) == intval($startRec)) { ?>
	<td><img src="images/lastdisab.gif" alt="Last" width="20" height="15" border="0"></td>
	<? } else { ?>
	<td><a href="FMSuscriptoreslist.asp?start=<?=$LastStart?>"><img src="images/last.gif" alt="Last" width="20" height="15" border="0"></a></td>
	<? } ?>
	<td><a href="FMSuscriptoresadd.asp"><img src="images/addnew.gif" alt="Add new" width="20" height="15" border="0"></a></td>
	<td><span class="aspmaker">&nbsp;de <?=intval(($totalRecs-1)/$displayRecs+1)?></span></td>
      </tr></table>	
</form>	
<?
		if (intval($startRec) > intval($totalRecs)) {
          $startRec=$totalRecs;
        }
        $stopRec=$startRec + $displayRecs-1;
        $recCount=$totalRecs-1;
        if ($rsEOF) {
          $recCount=$totalRecs;
        }
        if ($stopRec > $recCount) {
          $stopRec=$recCount;
        }
?>
	        <span class="aspmaker">Registro <?=$startRec ?>  a <?=$stopRec?> de <?=$totalRecs?></span>
            <? } else { ?>
	<span class="aspmaker">No se han encontrado registros</span>
<p>
<a href="FMSuscriptoresadd.asp"><img src="images/addnew.gif" alt="Add new" width="20" height="15" border="0"></a>
</p>
<? } ?>
</td></tr></table>
<?
	require "footer.asp";
?>