[RESOLVED] Photo Album - Rows/Cols

[dclamp]

I know this has been answered but, i want to display photos in 4 columns, and how ever many rows (depending on how many pics).

I tried searching the forums, but i am not sure what to search for

[nebulom]

if $count++ % 4 == 0 && $count != 0 Create another tr?

[dclamp]

im sorry, you lost me. can you please repost with a description and maybe with PHP tags, thanks.

[nebulom]

This is just created on the fly so there might be errors but it's more or less something like this

$count = 0;
echo "<tr>";
foreach ($pics as $pic) {
	echo "<td><img></td>";
	if ($count++ % 4 == 0 && $count != 0) {
		echo "</tr><tr>";
	}
}
echo "</tr>";

[nebulom]

Ops, it should be

$pics = array('pic 1', 'pic 2', 'pic 3', 'pic 4', 'pic 5', 'pic 6');
	echo "<table><tr>";
	foreach ($pics as $pic) {
		if ($count++ % 4 == 0 && $count != 0) {
			echo "</tr><tr>";
		}
		echo "<td>$pic</td>";
	}
	echo "<tr></table>";

[dclamp]

i am going to be getting the pictures from a database, does that make a difference?

[nebulom]

Nope.

[dclamp]

well would the array be something like this:

$pics = mysql_fetch_array 

[nebulom]

Are you storing it as blob? Or just reference path? If it's blob, it would be another thread I guess but if it's just reference path, it would be something like

$result = mysql_query("select img from img_table");
	echo "<table><tr>";
	$count = 0;
	while ($row = mysql_fetch_array($result)) {
		extract($row);
		if ($count++ % 4 == 0 && $count != 0) {
			echo "</tr><tr>";
		}
		echo "<td><img src='$img'/></td>";
	}
	echo "<tr></table>";

But I'm fond of encapsulating the DAO to another layer that's why I have examples like above. Assuming I encapsulated the results to the $pics array.

[dclamp]

i think thats exactly what i am looking for. but i have to go right now. I will test it in the morning


thanks!

[dclamp]

ok the code didnt work. Here is what i worked out:

<?php
$result = mysql_query("SELECT * FROM `pictures` WHERE album='$_GET[albumid]' AND member_id='$_SESSION[member_id]'");
echo "<table><tr>";
$count = 0;
while ($a = mysql_fetch_array($result)) {
    extract($row);
    if ($count++ % 4 == 0 && $count != 0) {
        echo "</tr><tr>";
    }
    ?>
    <td>
        <img src='includes/image_resize.php?<?=$a['url']?>' title='<?=$a['caption']?>'><br> 
        <?=$a['caption']?><br>
        //some HTML here...
    </td>
    <?PHP
}
echo "</tr></table>";
?>

and here is the source from the browser:

<!--############ START ############ -->
<table><tr><tr></table>


<!--############ END ############ -->

[nebulom]

A little modification. $count = 0 to $count = 1 and works for me btw.

<?php
	mysql_connect('localhost', 'test', 'password');
	mysql_select_db('test');
	
	$result = mysql_query("select path from pictures");
	echo "<table><tr>";
	$count = 1;
	while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
		extract($row);
		echo "<td><img src='$path'></td>";
		if ($count++ % 4 == 0) {
			echo "</tr><tr>";
		}
	}
	echo "</tr></table>";
?>

Edit: Page Source

<table><tr><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td></tr><tr><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td></tr><tr><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td></tr><tr><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td></tr><tr><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td></tr><tr><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td></tr><tr><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td></tr><tr><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td></tr><tr><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td></tr><tr><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td></tr><tr><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td></tr><tr><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td><td><img src='images/pic1.png'></td></tr></table>

[dclamp]

i must be having a mysql error then. Thanks!

[dclamp]

i have used this code like 2 or 3 times without any problems, and not i am trying to implement it on another site, and it is telling me i have an "unexpected $end on line 1".

I normally get thoes when i open a if statment, and dont close it.

I checked all the if / else statments and they all closed... and i am not sure what is happening

[penagate]

Check that no path is specified in the auto_prepend_file INI setting.

[dclamp]

i cant access my ini file

[dclamp]

ok, no file is there.