Viewing file: funcionarios.php (1.69 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php require_once('../../Connections/l2006.php'); ?>
<?php
$maxRows_rsfunc = 10;
$pageNum_rsfunc = 0;
if (isset($_GET['pageNum_rsfunc'])) {
$pageNum_rsfunc = $_GET['pageNum_rsfunc'];
}
$startRow_rsfunc = $pageNum_rsfunc * $maxRows_rsfunc;
mysql_select_db($database_l2006, $l2006);
$query_rsfunc = "SELECT * FROM nueva_2006_planta order by Apellidos";
$query_limit_rsfunc = sprintf("%s LIMIT %d, %d", $query_rsfunc, $startRow_rsfunc, $maxRows_rsfunc);
$rsfunc = mysql_query($query_limit_rsfunc, $l2006) or die(mysql_error());
$row_rsfunc = mysql_fetch_assoc($rsfunc);
if (isset($_GET['totalRows_rsfunc'])) {
$totalRows_rsfunc = $_GET['totalRows_rsfunc'];
} else {
$all_rsfunc = mysql_query($query_rsfunc);
$totalRows_rsfunc = mysql_num_rows($all_rsfunc);
}
$totalPages_rsfunc = ceil($totalRows_rsfunc/$maxRows_rsfunc)-1;
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<?php do { ?>
<table width="60%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20%"><?php echo $row_rsfunc['oficina']; ?></td>
<td width="20%"><?php echo $row_rsfunc['Cargo']; ?></td>
<td width="20%"><?php echo $row_rsfunc['Apellidos']; ?></td>
<td width="20%"><?php echo $row_rsfunc['Nombres']; ?></td>
<td width="20%"><?php echo $row_rsfunc['extension']; ?></td>
</tr>
</table>
<?php } while ($row_rsfunc = mysql_fetch_assoc($rsfunc)); ?></body>
</html>
<?php
mysql_free_result($rsfunc);
?>
|