coding a loop for an image gallary

Brad

Im trying to get a PHP/MySQL driven image gallary going for my site. I'm having problems though with the loop. I want to display 5-7 images per row. But I cannot seem to figure out how to specify the number of images per row and how to start a new row while still in the loop. I hope that makes sense. I can't seem to find a good tutorial on the subject either. Any help on sorting this out would be great.

paulnaj

Hi Brad and Installer,

Not sure, but it seems that you might get into a little trouble there if the number of rows doesn't divide the number of images exactly. 🙁

Here's a mysql version ...

<?php
$result = mysql_query('SELECT * FROM mytable');
$numrows = mysql_num_rows($result);

$rowlength = 7;
$counter = 0;

echo '<table border="1" cellpadding="2"><tr>';
while($row = mysql_fetch_row($result)){
	echo '<td>'.$row[0].'</td>';
	if(++$counter % $rowlength == 0){
		echo '</tr><tr>';
	}
}
// Need to add any 'extra' empty tds
if(($numextra = $rowlength - ($numrows % $rowlength)) !== 0){
	echo str_repeat('<td>&nbsp;</td>', $numextra);
}

echo '</tr></table>';
?>

Hope that helps.

Paul 🙂

Brad

Hey guys!
Thanks for the help. I will take a look at those and hopefully find my answer. Thanks again.

Brad

ok, now im confused...
where can I access and display the info from the 2 columns I am trying to access? Im trying the following but (obviously) to no avail. How do I access the values of id and thumbnail from the $row variable? This is what Im trying right now.

$query = "Select id, thumbnail from photo where category='" .$category. "'";
$result = mysql_query($query);
$numrows = mysql_num_rows($result);

							$rowlength = 7; 
							$counter = 0; 

							echo '<table border="1" cellpadding="2"><tr>'; 
							while($row = mysql_fetch_row($result))
								{ 
								echo "<td><a href='gallary/display.php?id=".$row[id]."'><img src='".$row[thumbnail]."' border='0' hspace='5'></a></td>"; 
								if(++$counter % $rowlength == 0)
									{ 
										echo '</tr><tr>'; 
									} 
								} 
							// Need to add any 'extra' empty tds 
							if(($numextra = $rowlength - ($numrows % $rowlength)) !== 0){ 
								echo str_repeat('<td>&nbsp;</td>', $numextra); 
							} 

							echo '</tr></table>';

paulnaj

No probs, Brad, just use the mysql_fetch_array() function rather than the mysql_fetch_row() that I used.

A tip ... use $row['id'] rather than $row[id], since the latter is dependent on server configuration and maybe 'turned off' on some servers 😉

Paul.