= $pages) && $pages != 1) { $last = $page + $limit; } //If not last results page, last result equals $page plus $limit. else { $last = $numrows; } // If last results page, last result equals total number of results. //escape from PHP mode. ?> \n"; echo "\n"; echo "$nome_completo rehearsal tracks page ".floor($current).""; ?>
Catalog $nome_completo karaoke track page ".floor($current)." \n"; ?>
Arias by $nome_completo    

$nome_completo rehearsal tracks

\n"; echo "
Results $first - $last of $numrows Page ".floor($current)." of $total
\n"; echo "
\n"; if ($page != 0) { // Don't show back link if current page is first page. $back_page = $page - $limit; echo "[back]\n"; } for ($i=1; $i <= $pages; $i++) // loop through each page and give link to it. { $ppage = $limit*($i - 1); if ($ppage == $page){ echo("$i \n");} // If current page don't give link, just text. else {echo "$i \n"; } } if (!((($page+$limit) / $limit) >= $pages) && $pages != 1) { // If last page don't give next link. $next_page = $page + $limit; echo " [next]\n"; } echo "\n"; // Now we can display results. $query4 = "SET NAMES utf8"; mysql_query($query4); $results = mysql_query("SELECT * FROM arie WHERE comp_id=$comp_id ORDER BY titolo LIMIT $page, $limit"); if (!$results) { die('Invalid query: ' . mysql_error()); } while ($data = mysql_fetch_array($results)) { //$compositore=$data["compositore"]; $titolo=$data["titolo"]; $link=$data["link"]; $opera=$data["opera"]; $personaggio=$data["personaggio"]; $comp_id=$data["comp_id"]; $aria_id=(integer)$data["aria_id"]; $voce=$data["voci_voce_id"]; $video=$data['video']; $clip_audio=$data["clip"]; $query2 = "SELECT * FROM voci WHERE voce_id=$voce"; $result2 = mysql_query($query2); $row2 = mysql_fetch_array($result2, MYSQL_ASSOC); $voce_link=$row2["voce_link"]; $voce_descr=$row2["voce_desc"]; $aria_link=get_aria_link($aria_id, $titolo, $keyword); echo "\n"; if (strlen($tiolo) > 38) { $data['titolo']=substr($titolo, 0, 36)."..."; } echo " \n"; echo ""; $isiPad = (bool) strpos($_SERVER['HTTP_USER_AGENT'],'iPad'); if ($isiPad==False || strstr($_SERVER['HTTP_USER_AGENT'],'iPhone') || strstr($_SERVER['HTTP_USER_AGENT'],'iPod')) { if ($video==1) { /*echo "\n";*/ echo ""; $video_preview=get_aria_video_preview($aria_id); /*echo "\n";*/ echo "\n"; } else { /*echo "";*/ echo ""; } } else { if ($video==1) { echo "\n"; echo "\n"; } else { echo "\n"; } } echo "\n"; echo "\n"; } echo "
Aria Opera Voice Preview Info
$titolo"; if ($massimo==$aria_id || $massimo==($aria_id-1) || $massimo==($aria_id-2) || $massimo==($aria_id-3)) { echo "new aria"; } if (strlen($opera) > 17) { $opera=substr($opera, 0, 16)."..."; } echo "$opera$voce_link audio preview  "; echo "
"; echo "
video preview video preview audio preview  "; echo "
"; echo "
audio preview video preview audio previewInfo / Buy
\n"; //echo ""; echo "
\n"; if ($page != 0) { // Don't show back link if current page is first page. $back_page = $page - $limit; echo "[back]\n"; } for ($i=1; $i <= $pages; $i++) // loop through each page and give link to it. { $ppage = $limit*($i - 1); if ($ppage == $page){ echo("$i \n");} // If current page don't give link, just text. else {echo "$i \n"; } } if (!((($page+$limit) / $limit) >= $pages) && $pages != 1) { // If last page don't give next link. $next_page = $page + $limit; echo " [next]\n"; } echo ""; ?>