Saludos.. ando de vuelta por aca y es q de verdad no le encuentro el error..
tengo un listado en donde no me está mostrando si no un solo resultado de todos los que debería mostrar.. aqui les dejo el código a ver si alguien ve el error...
La consulta
Código PHP:
<?php require_once('Connections/azimut.php'); ?>
<?php
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;
}
}
$maxRows_Recordset1 = 20;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_azimut, $azimut);
$query_Recordset1 = "SELECT * FROM equipo";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $azimut) or die(mysql_error());
$row = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>
El llamado y ciclo
Código PHP:
<?php
$claro = "FCE4D6";
do {
if($claro=="FCE4D6"){$claro="FFFFFF";} else {$claro="FCE4D6";};
?>
<table width="100%" border="0" cellspacing="2" cellpadding="0">
<tr bgcolor="#<?php print $claro ?>">
<td bgcolor="#<?php print $claro ?>"><table width="100%" border="0" align="center" cellspacing="1">
<tr>
<td width="40%" align="center" class="textoINDEX"><span class="textoINDEX"><?php echo $row['nombre']; ?></span></td>
<td width="25%" align="center" class="textoINDEX"><span class="textoINDEX"><?php echo $row['cargo']; ?></span></td>
<td align="center" class="textoINDEX"><span class="textoINDEX"><?php echo $row['contacto']; ?></span></td>
</tr>
</table></td>
</tr>
</table>
<?php } while ($row=mysql_fetch_assoc($sql_exec)); ?>