se me pasan 1000 cosas por la cabeza pero nose por donde empezar.
Código PHP:
<?
include "conexion.php";
$num=$_GET['num'];
if ( !is_null(@$_GET["num"]) ){
$query = "select imei, unlockcode1, unlockcode2, Tipo, DataEnv, DataRec, Estado from `IMEIS` where `Estado`='En Espera' ORDER BY DataEnv ASC LIMIT ".$num.",10";
$resultat=mysql_query($query);
}
else{
$query = "select imei, unlockcode1, unlockcode2, Tipo, DataEnv, DataRec, Estado from `IMEIS` where `Estado`='En Espera' ORDER BY DataEnv ASC LIMIT 0,10";
echo $query;
$resultat=mysql_query($query);
}
echo "<table border = '1'> \n";
echo "<tr> \n";
echo "<td><b>IMEI</b></td> \n";
echo "<td><b>UnlockCode1</b></td> \n";
echo "<td><b>UnlockCode2</b></td> \n";
echo "<td><b>Tipo</b></td> \n";
echo "<td><b>Data envio</b></td> \n";
echo "<td><b>Data Recepcion</b></td> \n";
echo "<td><b>Estado</b></td> \n";
echo "</tr> \n";
while ($row = mysql_fetch_row($resultat)){
echo "<tr> \n";
echo "<td>$row[0]</td> \n";
echo "<td>$row[1]</td> \n";
echo "<td>$row[2]</td> \n";
echo "<td>$row[3]</td> \n";
echo "<td>$row[4]</td> \n";
echo "<td>$row[5]</td> \n";
echo "<td>$row[6]</td> \n";
echo "</tr> \n";
}
$query = "select imei, unlockcode1, unlockcode2, Tipo, DataEnv, DataRec, Estado from `IMEIS` where `Estado`='En Espera'";
$result = mysql_query($query);
$paginaactual=1;
$numregistres=mysql_num_rows($result);
$numpagines=$numregistres / 10;
$z=-10;
echo "Pagines<br>";
echo ".: ";
for ($i=1;$i<=$numpagines+1;$i++)
{
$z=$z+10;
echo "<a href=\"archivo.php?num=".$z."\">".$i." </a>";
$limit=$i*$z;
}
echo ":. ";
?> 
