Hola todos :)
Tengo esto y estoy utilizando el Paginator:
Código PHP:
<div align="center">
<strong><center>INVESTMENT HISTORY (MEMBERS WITH UPGRADE)</strong></font><br><br>
<form method="POST" action="list_upgrades_pagi.php">
<font color="#0099CC">View members with upgrades number equal to </font>
<input type="text" name="T1" size="3"></font>
<br><input type="submit" value="Send" name="B1"><input type="reset" value="Reset" name="B2"></p><br>
</div>
<?
if ($_POST["B1"]) {
$view=$_POST["T1"];
// echo "view $view";
if ($view==0) {
echo "<center><font color=red>Please enter a number > zero</font></center>";
exit();
}
$_pagi_sql=("SELECT DISTINCT usrid AS USER, user.name AS NAME, user.email AS EMAIL, COUNT(usrid) AS COUNT FROM investment_history, user WHERE user.id=investment_history.usrid GROUP BY usrid HAVING COUNT(usrid)='$view'");
$_pagi_propagar = array(
'view',
);
include("paginator.inc.php");
if ($row= mysql_fetch_array($_pagi_result))
{
$count=$row["COUNT"];
$usrid=$row["USER"];
//echo "<strong><center>INVESTMENT HISTORY (MEMBERS WITH UPGRADE)</strong></font><br><br>";
echo "<TABLE BORDER='1'>";
echo "<TR><TD bgcolor='DARKCYAN' align='center'><font color=white><small><small>USERID</small></small></TD><TD bgcolor='DARKCYAN' align='center'><font color=white><small><small>NAME</small></small></TD><TD bgcolor='DARKCYAN' align='center'><font color=white><small><small>EMAIL</small></small></TD><TD bgcolor='DARKCYAN' align='center'><font color=white><small><small>UPGRADES BOUGHT</small></small></TD></TR>";
DO {
$alt=="alt1" ? $alt="alt2" : $alt="alt1"; # Cambia el color
echo "<TR class='$alt'><TD align='center'><small><small>".$row["USER"]."</small></small></TD><TD align='center'><small><small>".$row["NAME"]."</small></small></TD><TD align='center'><small><small>".$row["EMAIL"]."</small></small></TD><TD align='center'><small><small>".$row["COUNT"]."</small></small></TD></TR>";
//echo "aqui $count $usrid";
}
WHILE ($row=mysql_fetch_array($_pagi_result));
echo "\t</tr>\n";
echo "</TABLE>";
//echo "Records on this page: ".mysql_num_rows($_pagi_result);
//Incluimos la barra de navegación
echo"<p><small>".$_pagi_navegacion."</small></p>";
echo"<p><small>".$_pagi_info."</small></p>";
}
else
{
echo "No upgrade bought";
}
}
?>
<br><center><font size=2 face=verdana><a href="/control/?y=0">Back to admin area</a></font></center>
Mi primer problema se resolvió cambiando la variable $_pagi_conteo_alternativo a true.
Pero ahora si tengo más de una página para mostrar a partir de la 2da. están todas vacías y hasta donde yo veo la única variable que tengo que progagar es 'view' pero no hay forma.
Una ayudita ?
Muchas gracias.