les paso consulta a la base que van arriba del do ..
Código PHP:
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
$user_Recordset1 = "-1";
if (isset($_SESSION['MM_Username'])) {
$user_Recordset1 = $_SESSION['MM_Username'];
}
mysql_select_db($database_reservas, $reservas);
$query_Recordset1 = sprintf("SELECT * FROM reserva_dat, clientes_huesped, clientes WHERE clientes.usuario= %s AND reserva_dat.alojamiento_id =clientes.id_alojar AND clientes_huesped.huesped_id = reserva_dat.id_huesped AND estado_reserva='R' ORDER BY reserva_dat.reservas_id ", GetSQLValueString($user_Recordset1, "text"));
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $reservas) or die(mysql_error());
$row_Recordset1 = 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;
$maxRows_reserva_detalle = 10;
$pageNum_reserva_detalle = 0;
if (isset($_GET['pageNum_reserva_detalle'])) {
$pageNum_reserva_detalle = $_GET['pageNum_reserva_detalle'];
}
$startRow_reserva_detalle = $pageNum_reserva_detalle * $maxRows_reserva_detalle;
$user2_reserva_detalle = "-1";
if (isset($_SESSION['MM_Username'])) {
$user2_reserva_detalle = $_SESSION['MM_Username'];
}
mysql_select_db($database_reservas, $reservas);
$query_reserva_detalle = sprintf("SELECT * FROM reserva_dat, reservas_det, habitaciones, clientes WHERE clientes.usuario= %s AND reserva_dat.alojamiento_id =clientes.id_alojar AND reservas_det.Localizador=reserva_dat.Localizador AND reservas_det.id_habitacion = habitaciones.hab_id ", GetSQLValueString($user2_reserva_detalle, "text"));
$query_limit_reserva_detalle = sprintf("%s LIMIT %d, %d", $query_reserva_detalle, $startRow_reserva_detalle, $maxRows_reserva_detalle);
$reserva_detalle = mysql_query($query_limit_reserva_detalle, $reservas) or die(mysql_error());
$row_reserva_detalle = mysql_fetch_assoc($reserva_detalle);
if (isset($_GET['totalRows_reserva_detalle'])) {
$totalRows_reserva_detalle = $_GET['totalRows_reserva_detalle'];
} else {
$all_reserva_detalle = mysql_query($query_reserva_detalle);
$totalRows_reserva_detalle = mysql_num_rows($all_reserva_detalle);
}
$totalPages_reserva_detalle = ceil($totalRows_reserva_detalle/$maxRows_reserva_detalle)-1;
$colname_Recordset3 = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_Recordset3 = $_SESSION['MM_Username'];
}
mysql_select_db($database_reservas, $reservas);
$query_Recordset3 = sprintf("SELECT * FROM clientes WHERE usuario = %s", GetSQLValueString($colname_Recordset3, "text"));
$Recordset3 = mysql_query($query_Recordset3, $reservas) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);
$user_alojamiento = "-1";
if (isset($_SESSION['MM_Username'])) {
$user_alojamiento = $_SESSION['MM_Username'];
}
mysql_select_db($database_reservas, $reservas);
$query_alojamiento = sprintf("SELECT * FROM alojamientos, clientes WHERE alojamientos.alojar_id = clientes.id_alojar AND clientes.usuario = %s", GetSQLValueString($user_alojamiento, "text"));
$alojamiento = mysql_query($query_alojamiento, $reservas) or die(mysql_error());
$row_alojamiento = mysql_fetch_assoc($alojamiento);
$totalRows_alojamiento = mysql_num_rows($alojamiento);
$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Recordset1") == false &&
stristr($param, "totalRows_Recordset1") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
$queryString_Recordset2 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Recordset2") == false &&
stristr($param, "totalRows_Recordset2") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Recordset2 = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_Recordset2 = sprintf("&totalRows_Recordset2=%d%s", $totalRows_Recordset2, $queryString_Recordset2);