# PHP limit \*file\* results not \*search\* results

**URL:** <https://forum.kirupa.com/t/php-limit-file-results-not-search-results/70924>\
**Category:** programming\
**Created:** [November 18, 2004, 10:30pm UTC](https://forum.kirupa.com/t/php-limit-file-results-not-search-results/70924 "2004-11-18T22:30:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sticmann](https://avatars.discourse-cdn.com/v4/letter/s/3e96dc/32.png) [@sticmann](https://forum.kirupa.com/u/sticmann)\
**Post date:** [November 18, 2004, 10:30pm UTC](https://forum.kirupa.com/t/php-limit-file-results-not-search-results/70924/1 "2004-11-18T22:30:53Z")

</div>

I have a dynamic gallery that pulls info from a database (name, title, description) and then outputs those along with thumbnail pics to the html.  
Here is the meat:

```php
$result = mysql_query("SELECT * FROM gallery");
  while ($myrow = mysql_fetch_array($result)) {
  	$name = $myrow["name"];
  	$title = $myrow["title"];
  	$description = $myrow["description"];
  	$dir = "/home/marchlew/public_html/images/".$name."/thumbs"; 
  	$handle = opendir($dir);
  	printf("<p>%s</p>
<p>%s</p>", $title, $description);
  ?>
  	<table border="0" align="center" cellpadding="0" cellspacing="0">
  	   <tr align="center">
  <?PHP
  
  		  while (false !== ($file = readdir($handle))) {
  			 if ($file != "." && $file != "..") {
  				 //build the table rows
 				 printf("<td><a href=\"javascript:popImage('images/%s/pics/%s','%s')\"><img src=images/%s/thumbs/%s hspace=5 border=0 ></a></td>
", $name, $file, $title, $name, $file);
  			 }
  		  }
  ?>
  	  </tr>
  	</table>
  

```

It does just what it should, but I want it to work a little differently. When the php searches through the directory, I want to limit the results to 5 files and then start with a new table for the rest of the pics.  
Something like:

```php

  ...get the db stuff
  ***
  	<table border="0" align="center" cellpadding="0" cellspacing="0">
   	   <tr align="center">
   <?PHP
   
   		  while (false !== ($file = readdir($handle))) {
   			 if ($file != "." && $file != "..") {
   				 //build the table rows
 				 printf("<td><a href=\"javascript:popImage('images/%s/pics/%s','%s')\"><img src=images/%s/thumbs/%s hspace=5 border=0 ></a></td>
", $name, $file, $title, $name, $file);
  
  ...start counting files
  
   ...when we get to 5, go back to *** and start a new table
  
   			 }
   		  }
   ?>
   	  </tr>
   	</table>
   

```

I can do the file count, but I don’t know how to get it to go back and start a new table, or how to get it to pick up with the file it left off with.  
To see it in practice, visit [http://marchlewskiguitars.com/gallery.php](http://marchlewskiguitars.com/gallery.php)

Thanks,  
-Joshua