Hello I have tehe code: PHP: $qry = "SELECT brand_name, brand_logo, site_link, video_link FROM tableName where catagory = 'Taxi'";$result = mysql_query($qry) or die (mysql_error());while ($row = mysql_fetch_assoc($result)){?><div id="categ"> <div id="inside"><?php echo $row['brand_name']; ?></div> <div id="inside1"><a href="#"><img src="<?php echo $row['brand_logo']; ?>" /></a></div> <div id="inside2"><?php echo $row['short_desc']; ?> <a href="<?php echo $row['site_link']; ?>">continuare</a> </div> <div id="inside3"><a rel="shadowbox;width=405;height=340" title="Restaurant Daniel - New York, NY" href="<?php echo $row['video_link']; ?>"><img src="img/tur_act.jpg" /></a></div> </div> <?php } ?> This cod select from table all rows from a category and put it on a div how it is show in the attach.problem is that it shows all the rows for this category (Taxi) but I want to show for exeample 10 results per page and generate a numeric list that will create a link to next page that will show me next result for this category.