Codice PHP:
function lingueDD($id,$limit) {
$sql_pag = mysql_query("SELECT * FROM Lingue ORDER BY IDLingue DESC") or die( mysql_error( ) );
$res_amt = mysql_num_rows($sql_pag);
$last = ceil($res_amt/$limit);
if(!isset($_GET['page']) || $_GET['page'] < 1)
{
$page = 1;
}
else
{
$page = $_GET['page'];
}
//This sets the range to display in our query
$max = 'limit ' .($page - 1) * $limit .',' .$limit;
//
$offset = ceil(($page - 1) * $limit);
$str = '<select name="listingMenu" class="textFields" onchange="jumpMenu(\'parent\',this,0)">';
$sql = mysql_query("SELECT * FROM Lingue ORDER BY IDLingue DESC $max") or die( mysql_error() );
while($rows = mysql_fetch_assoc($sql))
{
$str .= '<option value="index.php?modID=87&compID=104&id='.$rows['IDLingue'].'&page='.$pagenum.'#'.$rows['IDLingue'].'">[['.$rows['IDLingue'].']]</option>'; }
$str .= "</select>";
return $str;
}