Displaying repeated regions in a table

[gemini85]

There is probably a simple solution to this but as a newbie to php/mysql i'm having difficulties with this..

I have a database containing 3 fields for images (ID, name, path). I am wanting to use the data in an image gallery. Thinking it would be fairly easy to do I created a table in dreamweaver 6 columns by 1 row and inserted a repeating region in the 1st column. The end result was the images loaded next to each other making one huge row. I tried moving things about a little but all i can get is either a long columb or row, I cant get the images to load up one after the other in a 6 by n format.

Heres the code I am using:

<?php
mysql_select_db($database_filmuk_db, $filmuk_db);
$query_thumb_view = "SELECT * FROM image ORDER BY ID ASC";
$thumb_view = mysql_query($query_thumb_view, $filmuk_db) or die(mysql_error());
$row_thumb_view = mysql_fetch_assoc($thumb_view);
$totalRows_thumb_view = mysql_num_rows($thumb_view);
?>



<table width="600" border="1" cellpadding="0" cellspacing="0">
         <?php do { ?><tr> 
          <td width="100" height="100"><img src="/admin/<?php echo $row_thumb_view['path']; ?>" width="100" height="100" border="0"></img></td>
 <td width="100" height="100>&nbsp;</td>
<td width="100" height="100">&nbsp;</td>
<td width="100"height="100">&nbsp;</td>
<td width="100" height="100>&nbsp;</td>
<td width="100"height="100">&nbsp;</td>

    </tr><?php } while ($row_thumb_view = mysql_fetch_assoc($thumb_view)); ?>
  </table>

I've put blank spaces in 5 of the 6 columns to make the code as mess free as possible. Im wanting to be able to call the images from the database and fil the 6 columns and extra rows with a different image from the database. How can I do this?

Thanks in advance🙂

[LordShryku]

There's probably an easier way, but I've been drinking 😃

Completely untested....just for a push in the directions I think I'm thinking....

<?php
/* sql, fetch, num_rows, blah blah
 * we'll need the total rows
 * $totalRows_thumb_view = mysql_num_rows($thumb_view);
 */

<?php
$break = 6; // number to break at
$clean = (($totalRows_thumb_view % $break) == 0) ? true : false; // will we end clean?
$total = 0; // ongoing counter
$i     = 0; // counter
<table width="600" border="1" cellpadding="0" cellspacing="0">
  <tr>
<?php
while($row_thumb_view = mysql_fetch_assoc($thumb_view)) {
   // increment counters
   $total++;
   $i++;
?>
    <td width="100" height="100"><img
     src="/admin/<?php echo $row_thumb_view['path']; ?>" width="100" height="100" border="0" />
    </td>
<?php
   if($i == $break) {
      $i = 0; // reset counter
      // end the row
?>
  </tr>
<?php
      if($total < $totalRows_thumb_view) {
         // create new row
?>
  <tr>
<?php
      }
   }
}
if(!$clean) {
?>
  </tr>
<?php
}
?>
</table>

[gemini85]

I know a bit of time has passed and I never replied but when your PC decides it wants wiped and you lose everything what can you do lol :mad:. Other excuse is I was new here so couldnt remember the link (but dont tell anyone😉) lol.

Anyway.... After some slight debugging (beer and coding dont go well 😉) everything worked (hurah!!!). Noticed one little thing that annoys me but noone else seems to notice and thats the images I put in the table always have a gap of a few pixels between them and the table border on the left and right. The images are perfectly square 100x100pixels and theres no cellpadding on the table so its a weird one. Other than that I've had no problems with it. Theres probably no way to fix the gaps (think its something to do with the way the table is put together🙁)

Thanks for your help LordShryku (sory for the huuuuuge delay in thanking you)

[rachel2004]

Resize all of your pics on the fly. See the PHP manual for imagecopyresampled function. They have some good user comments that will most likely solve your problem.

[gemini85]

But surely if I've told the table to make each cell 100x100 and the pics are the same size then there shouldnt be any gaps between the left and right sides of the cell borders? I've tried making the images slightly bigger than 100x100 and I still get the same problem. if I have to use the imagecopyresampled function then fine but I thought there was a simpler solution to the problem 😕

Thanks anyway rachel2004 🙂

[rachel2004]

I obviously read through this post too quickly. You don't need to resize your pics. Okay, looking through LordShryku's code, I see he has cellpadding set to 0. Is that still the same in your code since you may have modified what he has? Are you certain that all pics are identically sized? Are you using any spacer.gifs? Programs like Dreamweaver sometimes insert that.

What do you have your table border set to?

[gemini85]

<?php 
/* sql, fetch, num_rows, blah blah 
* we'll need the total rows 
* $totalRows_gallery = mysql_num_rows($gallery); 
*/ 

$break = 6; // number to break at 
$clean = (($totalRows_gallery % $break) == 0) ? true : false; // will we end clean? 
$total = 0; // ongoing counter 
$i     = 0; // counter ?>
<table width="600" border="1" cellpadding="0" cellspacing="0"> 
  <tr> 
<?php 
while($row_gallery = mysql_fetch_assoc($gallery)) { 
   // increment counters 
   $total++; 
   $i++; 
?> 
          <td width="100" height="100">
		  <a href="profileMA.php?profileID=<?php echo $row_gallery['id']; ?>" target="_blank" border="0">
		  <img src="/admin/<?php echo $row_gallery['image']; ?>" border="0" width="100" height="100" alt="<?php echo $row_gallery['name']; ?>"/></a> 
		  </td>

<?php 
   if($i == $break) { 
      $i = 0; // reset counter 
      // end the row 
?> 
  </tr> 
<?php 
      if($total < $totalRows_gallery) { 
         // create new row 
?> 
  <tr> 
<?php 
      } 
   } 
} 
if(!$clean) { 
?> 
  </tr> 
<?php 
} 
?> 
</table>

Thats what I'm using now. As you can see I've ironed out the few little errors LordShryku's drunkenness caused lol. Borders set to 1 for the table and 0 for the image link (never have liked link borders around images:p) Dontthink I made any real changes to the code as it was pretty much everything I was looking for 🙂. the images are definatly square but as you'll see I've also added the height and width to the img tag to make sure that everything is perfectly square... but its not 😕

[rachel2004]

Are you sure the images are 100 x 100? It is difficult to troubleshoot problems like this without visiting the website and checking your source code in the browser.