primero que todo gracias por tu respuesta, mira aqui te dejo el codigo para que veas lo que llevo, aun no logro sumar e imprimir el total
Código PHP:
<?php require_once('../Connections/estudio.php'); ?>
<?php
require_once('../includes/common/KT_common.php');
require_once('../includes/tfi/TFI.php');
require_once('../includes/tso/TSO.php');
require_once('../includes/nav/NAV.php');
$conn_estudio = new KT_connection($estudio, $database_estudio);
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{ $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;}
return $theValue;}}
$tfi_listdeuda1 = new TFI_TableFilter($conn_estudio, "tfi_listdeuda1");
$tfi_listdeuda1->addColumn("deuda.deuda", "STRING_TYPE", "deuda", "%");
$tfi_listdeuda1->Execute();
$tso_listdeuda1 = new TSO_TableSorter("rsdeuda1", "tso_listdeuda1");
$tso_listdeuda1->addColumn("deuda.deuda");
$tso_listdeuda1->setDefault("deuda.deuda");
$tso_listdeuda1->Execute();
$nav_listdeuda1 = new NAV_Regular("nav_listdeuda1", "rsdeuda1", "../", $_SERVER['PHP_SELF'], 20);
$maxRows_rsdeuda1 = $_SESSION['max_rows_nav_listdeuda1'];
$pageNum_rsdeuda1 = 0;
if (isset($_GET['pageNum_rsdeuda1'])) {
$pageNum_rsdeuda1 = $_GET['pageNum_rsdeuda1'];}
$startRow_rsdeuda1 = $pageNum_rsdeuda1 * $maxRows_rsdeuda1;
$NXTFilter_rsdeuda1 = "1=1";
if (isset($_SESSION['filter_tfi_listdeuda1'])) {
$NXTFilter_rsdeuda1 = $_SESSION['filter_tfi_listdeuda1'];}
$NXTSort_rsdeuda1 = "deuda.deuda";
if (isset($_SESSION['sorter_tso_listdeuda1'])) {
$NXTSort_rsdeuda1 = $_SESSION['sorter_tso_listdeuda1'];}
mysql_select_db($database_estudio, $estudio);
$query_rsdeuda1 = "SELECT deuda.deuda, deuda.id_deuda, deuda.monto FROM deuda WHERE {$NXTFilter_rsdeuda1} ORDER BY {$NXTSort_rsdeuda1}";
$query_limit_rsdeuda1 = sprintf("%s LIMIT %d, %d", $query_rsdeuda1, $startRow_rsdeuda1, $maxRows_rsdeuda1);
$rsdeuda1 = mysql_query($query_limit_rsdeuda1, $estudio) or die(mysql_error());
$row_rsdeuda1 = mysql_fetch_assoc($rsdeuda1);
if (isset($_GET['totalRows_rsdeuda1'])) {
$totalRows_rsdeuda1 = $_GET['totalRows_rsdeuda1'];
} else { $all_rsdeuda1 = mysql_query($query_rsdeuda1);
$totalRows_rsdeuda1 = mysql_num_rows($all_rsdeuda1);}
$totalPages_rsdeuda1 = ceil($totalRows_rsdeuda1/$maxRows_rsdeuda1)-1;
$nav_listdeuda1->checkBoundries();
?><!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>Documento sin título</title>
<link href="includes/skins/mxkollection3.css" rel="stylesheet" type="text/css" media="all" />
<script src="../includes/common/js/base.js" type="text/javascript"></script>
<script src="../includes/common/js/utility.js" type="text/javascript"></script>
<script src="../includes/skins/style.js" type="text/javascript"></script>
<script src="../includes/nxt/scripts/list.js" type="text/javascript"></script>
<script src="../includes/nxt/scripts/list.js.php" type="text/javascript"></script>
<script type="text/javascript">
$NXT_LIST_SETTINGS = {
duplicate_buttons: true,
duplicate_navigation: false,
row_effects: true,
show_as_buttons: true,
record_counter: false}
</script>
<style type="text/css">
@import url("style/principal.css");
.KT_col_deuda {width:600px; overflow:hidden;}
</style>
</head>
<body>
<table cellspacing="0" cellpadding="0" class="menusuper">
<tr><td>Ubicación: deuda</td>
</tr></table><div class="KT_tng" id="listdeuda1"> <div class="KT_tnglist">
<form action="<?php echo KT_escapeAttribute(KT_getFullUri()); ?>" method="post" id="form1"> <div class="KT_options"> <a href="<?php echo $nav_listdeuda1->getShowAllLink(); ?>"><?php echo NXT_getResource("Show"); ?> <?php
if (@$_GET['show_all_nav_listdeuda1'] == 1) {
?> <?php echo $_SESSION['default_max_rows_nav_listdeuda1']; ?>
<?php } else { ?>
<?php echo NXT_getResource("all"); ?>
<?php } ?>
<?php echo NXT_getResource("records"); ?></a>
<a href="<?php echo $tfi_listdeuda1->getResetFilterLink(); ?>"><?php echo NXT_getResource("Reset filter"); ?></a></div>
<table cellpadding="2" cellspacing="0" class="KT_tngtable">
<thead>
<tr class="KT_row_order">
<th> <input type="checkbox" name="KT_selAll" id="KT_selAll"/> </th>
<th colspan="2" class="KT_sorter KT_col_deuda <?php echo $tso_listdeuda1->getSortIcon('deuda.deuda'); ?>" id="deuda"> <a href="<?php echo $tso_listdeuda1->getSortLink('deuda.deuda'); ?>">deuda</a> </th>
<th> </th>
</tr><tr class="KT_row_filter"><td> </td>
<td colspan="2"><input type="text" name="tfi_listdeuda1_deuda" id="tfi_listdeuda1_deuda" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listdeuda1_deuda']); ?>" size="150" maxlength="150" /></td>
<td><input type="submit" name="tfi_listdeuda1" value="<?php echo NXT_getResource("Filter"); ?>" /></td> </tr>
</thead><tbody> <?php if ($totalRows_rsdeuda1 == 0) { // Show if recordset empty ?> <tr> <td colspan="4"><?php echo NXT_getResource("The table is empty or the filter you've selected is too restrictive."); ?></td> </tr>
<?php } // Show if recordset empty ?>
<?php if ($totalRows_rsdeuda1 > 0) { // Show if recordset not empty ?>
<?php do { ?>
<tr class="<?php echo @$cnt1++%2==0 ? "" : "KT_even"; ?>">
<td><input type="checkbox" name="kt_pk_deuda" class="id_checkbox" value="<?php echo $row_rsdeuda1['id_deuda']; ?>" />
<input type="hidden" name="id_deuda" class="id_field" value="<?php echo $row_rsdeuda1['id_deuda']; ?>" /> </td>
<td><div class="KT_col_deuda"><?php echo KT_FormatForList($row_rsdeuda1['deuda'], 80); ?></div></td>
<td><div class="KT_col_monto"><?php echo KT_FormatForList($row_rsdeuda1['monto'],20); ?></div></td>
<td><a href="id_deuda.php?id_deuda=<?php echo $row_rsdeuda1['id_deuda']; ?>&KT_back=1"><img src="images/editar.gif" alt="Modificar deuda" title="Modificar deuda" width="20" height="20" border="0" /></a> <a href="#delete"><img src="images/borrar.gif" alt="Eliminar deuda" title="Eliminar deuda" width="20" height="20" border="0" /></a> </td>
</tr><?php } while ($row_rsdeuda1 = mysql_fetch_assoc($rsdeuda1)); ?>
<?php } // Show if recordset not empty ?>
</tbody></table> <div class="KT_bottomnav"><div>
<?php $nav_listdeuda1->Prepare();
require("../includes/nav/NAV_Text_Navigation.inc.php");?>
<table width="200" border="1">
<tr><td>total: </td> </tr>
</table></div></div><div class="KT_bottombuttons"><div class="KT_operations"> <a class="KT_edit_op_link" href="#" onclick="nxt_list_edit_link_form(this); return false;"></a> <a class="KT_delete_op_link" href="#" onclick="nxt_list_delete_link_form(this); return false;"></a><div class="KT_operations"></div></div><select name="no_new" id="no_new"><option value="1">1</option><option value="3">3</option><option value="6">6</option></select><a class="KT_additem_op_link" href="id_deuda.php?KT_back=1" onclick="return nxt_list_additem(this)"><?php echo NXT_getResource("add new"); ?></a> </div>
</form></div><br class="clearfixplain" />
</div><p> </p></body></html>
<?php mysql_free_result($rsdeuda1); ?>