[HELP] Pagination

extream87

Hello all im getting 3 mysql stored things like nick, auth id, and skillpoints.
Im getting around 100 results and i need to make pagination but i dont know how.
I want to show only 30 results per page.

This is my code:

<?php
	require('config.php');

$iConnection = mysqli_connect($_HOST_,$_USER_,$_PASS_,$_MYDB_) or die("<link rel='stylesheet' type='text/css' href='style.css'><h4>Rank not found.</h4>")
?>

<html>
	<head>
		<title>sitename - ranking</title>
		<link rel="stylesheet" type="text/css" href="style.css">
	</head>
	<body>
		<table width="100%" border="0" cellpadding="1" cellspacing="1">
			<tr>
				<th>RANK</abbr></th>
				<th>JOGADOR</abbr></th>
				<th>STEAM ID</th>
				<th>SKILLPOINTS</th>
			</tr>
			<?php
				$sql = "SELECT * FROM iTUGA ORDER BY skillpoints DESC";

			$iResult = mysqli_query($iConnection, $sql);

			$i = 1;

			while($Row = mysqli_fetch_array($iResult))
			{
				echo (!($i % 2)) ? "<tr>" : "<tr id='c'>";

				switch($i)
				{
					case 1:
					{
						echo "<td style='text-align: center;' width='5%'><img src='images/1.png'></td>";

						break;
					}
					case 2:
					{
						echo "<td style='text-align: center;' width='5%'><img src='images/2.png'></td>";

						break;
					}
					case 3:
					{
						echo "<td style='text-align: center;' width='5%'><img src='images/3.png'></td>";

						break;
					}
					default:
					{
						echo "<td style='text-align: center;' width='5%'>" . $i . "</td>";



						break;
					}
				}

				echo "<td style='text-align: center;' width='9%'>" . $Row['nick'] . "</td>";
				echo "<td style='text-align: center;' width='9%'>" . $Row['authid'] . "</td>";
				echo "<td style='text-align: center;' width='9%'>" . $Row['skillpoints'] . "</td>";
				echo "</tr>";

				$i++;
			}

			mysqli_close($iConnection);
		?>
	</table>
</body>
</html>

Thanks all.

Weedpacket

Try searching the forums for "pagination" and you'll get a number of hits (including three linked in the Coding forum FAQ). There will be plenty of pointers on how to start among them.

extream87

Weedpacket thanks for your answer ive already searched but i get some errors and i dont know how to fix it.

Here is the code:

<?php
	require('config.php');

$iConnection = mysqli_connect($_HOST_,$_USER_,$_PASS_,$_MYDB_) or die("<link rel='stylesheet' type='text/css' href='style.css'><h4>Rank not found.</h4>")
?>

<html>
	<head>
		<title>sitename - ranking</title>
		<link rel="stylesheet" type="text/css" href="style.css">
	</head>
	<body>
		<p><img style="display: block; margin-left: auto; margin-right: auto;" src="http://i.imgur.com/Q51YR6x.png" alt="" width="500" height="100" /></p>
		<table width="100%" border="0" cellpadding="1" cellspacing="1">
			<tr>
				<th>RANK</abbr></th>
				<th>JOGADOR</abbr></th>
				<th>STEAM ID</th>
				<th>SKILLPOINTS</th>
			</tr>
			<?php
				$sql = "SELECT * FROM iTUGA ORDER BY skillpoints DESC;

		// PAGINATION START
		$pagenum = isset($_GET['pagenum']) ? $_GET['pagenum'] : 1;  

		$result = mysql_query($query); 
		$rows = mysql_num_rows($result); 
		$page_rows = 4; 
		$last = ceil($rows/$page_rows); 


		// Pagination information 
		if ($pagenum < 1){  
			$pagenum = 1; 
			}elseif($pagenum > $last){ 
				$pagenum = $last;  
			} 

		$max = " LIMIT ".($pagenum - 1) * $page_rows.", ".$page_rows.""; 
		$query2 = $query.$max; 
		$result2 = mysql_query($query2); 

		}  
		//END PAGINATION
			$iResult = mysqli_query($iConnection, $sql);

			$i = 1;

			while($Row = mysqli_fetch_array($iResult))
			{
				echo (!($i % 2)) ? "<tr>" : "<tr id='c'>";

				switch($i)
				{
					case 1:
					{
						echo "<td style='text-align: center;' width='5%'><img src='images/1.png'></td>";

						break;
					}
					case 2:
					{
						echo "<td style='text-align: center;' width='5%'><img src='images/2.png'></td>";

						break;
					}
					case 3:
					{
						echo "<td style='text-align: center;' width='5%'><img src='images/3.png'></td>";

						break;
					}
					default:
					{
						echo "<td style='text-align: center;' width='5%'>" . $i . "</td>";



						break;
					}
				}

				echo "<td style='text-align: center;' width='9%'>" . $Row['nick'] . "</td>";
				echo "<td style='text-align: center;' width='9%'>" . $Row['authid'] . "</td>";
				echo "<td style='text-align: center;' width='9%'>" . $Row['skillpoints'] . "</td>";
				echo "</tr>";

				$i++;
			}

			mysqli_close($iConnection);
		?>
	</table>
</body>
</html>

Bonesnap

It would be very helpful if you included the errors you were getting, otherwise how do we know what to look for?

One thing I noticed though is it appears you're mixing mysqli functions with mysql functions. I don't think you can do that. You will have to choose one (hint: choose mysqli_).