<table>
<?
				$rowsPerPage = 20;
				$pageNum = 1;
				if(isset($_GET['page']) && $_GET['page'] > 0)
				{
					$pageNum = $_GET['page'];
				}
				$offset = ($pageNum - 1) * $rowsPerPage;
				$query = " SELECT * FROM `products` " . " LIMIT $offset, $rowsPerPage";
				$result = mysql_query($query) or die ("MySQL Error: ".mysql_error($linkid));
				while($row = mysql_fetch_array($result))
				{
					echo "<tr><td>שם המוצר : " . $row['name'] . "</td></tr>";
					echo "<tr><td>מחיר : " .$row['price'] . "</td></tr>";
				}
?>
		</table>
<?
				$query   = "SELECT * FROM products";
				$result  = mysql_query($query);
				$numrows = mysql_num_rows($result);
				$maxPage = ceil($numrows/$rowsPerPage);
				$self = "index.php";
					if ($pageNum > 1)
					{
						$page  = $pageNum - 1;
						$prev  = "<a href=\"index.php?page=".$page."\">הקודם</a>";
					}else{
						$prev  = ' ';
						$first = ' ';
					}
					if ($pageNum < $maxPage) {
						$page = $pageNum + 1;
						$next  = "<a href=\"index.php?page=".$page."\">הבא</a>";
					}else{
						$next = ' ';
						$last = ' ';
					}
					echo $prev . $next;
?>